Query on Compound Index

[mark]

What pagination are you referring to? How's it generated?

Can you provide an example of the sort disorder? Include all three columns, rank, last, first, in the list.

[Texis User]

I have sent a mail to help@.. since there is no option to upload documents on the forum.

Screen 1 shows result when there is not business selected
So the query would be
-----------------

select * from person_profile
where first_name\last_name\sc_first_name\sc_last_name\middle_initial\preferred_name likep 'kad*' and active_flag=0 order by $rank,initcap(last_name),initcap(first_name)

---------------------

Screen 2 shows result when there is business selected
So the query would be
---------------------

select * from person_profile
where first_name\last_name\sc_first_name\sc_last_name\middle_initial\preferred_name likep 'kad*' and active_flag=0 and business_name = 'GE Infrastructure' order by $rank,initcap(last_name),initcap(first_name)
----------------------------------

[mark]

Just provide a few rows around the sort disorder, not the whole output.

Don't send mail to "help", it will be ignored. If you want to open a ticket you may do so from the tech support link.

[Texis User]

My foremost problem is pagination as mentioned in above query and was hoping some solution on that.

People don't realize the sort issue as much as they do for pagination.


I cannot paste data as it is confidential.

[mark]

What pagination are you referring to? How's it generated?