I know this has been asked 1000 times, but I did not see it on the forum.
I am using IICE 8.4.x and I want to request my Query object to sort on a specific column in descending order. I am using the Query.setSortSpecifications... to perform this task. Is the actual sorting performed on CM before they are sent to me, or are all the rows sent to my IICE environment and the sorting is performed by IICE (i.e. CM connector?)
Pinned topic Sorting on a Content Manager Query, where is it performed?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-05-06T17:43:30Z at 2010-05-06T17:43:30Z by SystemAdmin
JCanipe 060000CWUM88 Posts
Re: Sorting on a Content Manager Query, where is it performed?2010-05-05T19:30:27ZThis is the accepted answer. This is the accepted answer.One more point to include: Let's say there are 1000 rows in CM that meet my specific Selection Criteria. I tell the Query object that I only want 100 (setMaxResults(100))and I want them sorted descending by a certain column. Please explain how many rows CM will send my layer and who will sort these rows.
SystemAdmin 110000D4XK254 Posts
Re: Sorting on a Content Manager Query, where is it performed?2010-05-06T17:43:30ZThis is the accepted answer. This is the accepted answer.
- JCanipe 060000CWUM
The Content Manager connector uses repository-native sorting, which means that the results come back to the connector sorted (if you specified sort specifications). IICE will not do any further sorting in this connector. The max results are also handled by the repository, for this connector.
If you specify both sort specifications and max results, then the repository should return the top up to max results # of values that were at the top of the sorted list.