Hi All,
How do I set the sort order of a XPages view control that is filtered with a search query?
I have a view named “VIEW1” and set the “search” to some query, that works fine, but my search result is not sorted the same as my view. I see 2 other settings “sortColumn” and “sortOrder” just below the “search” but I can’t seem to figure out how to use them.
Ideas? What am I missing?
I will be very thankful to you for your kind response.
With Regards,
Vikas K Sinha
Subject: Solution
Hi
Using the search part of the view XPage control alone will run a full-text search on the database and return the values based on relevance (hence why you need the database FT Indexed)
To be able to sort the data you search for, you need to change the way the data is searched. The following article (and demo app) explain this
Ian
Subject: Another solution
See this blog post: http://www.bleedyellow.com/blogs/m.leusink/entry/xpages_sort_the_results_of_a_full_text_query_server_side_and_by_any_column_corrected1?lang=en