topic Re: Improper sorting when using pagination in Alfresco Archive

Improper sorting when using pagination

leggebroten — Wed, 09 Jul 2014 19:22:16 GMT

It seems that sorting and pagination don't work as I expect.I had expected that the sort would be applied BEFORE choosing a page from the sorted results.Instead the sort seems to be applied AFTER getting the specified page.Behavior is consistent between both REST and the Java library For example:RES

Re: Improper sorting when using pagination

leggebroten — Wed, 09 Jul 2014 21:16:05 GMT

A unit test to demonstrate the behavior.
Output 100 tasks sorted by dueDate as one page.
Followed by same query paginated via "listPage" by 10 pages of 10 tasks each.

Re: Improper sorting when using pagination

leggebroten — Fri, 18 Jul 2014 14:54:58 GMT

bump

Re: Improper sorting when using pagination

trademak — Mon, 21 Jul 2014 09:04:35 GMT

In your unit test you use includeProcessVariables. There's an issue with database sorting with the variables query on some databases. That's why we do that bit in memory. If you don't included the process variables in the query it will use database sorting.

Best regards,

Re: Improper sorting when using pagination

leggebroten — Thu, 24 Jul 2014 17:25:28 GMT

Interesting. I guess that would explain why Activiti-Explorer was showing the same bad behavior when trying to sort completed tasks by due date

Re: Improper sorting when using pagination

tgebeyehu — Tue, 14 Jun 2016 13:20:37 GMT

Hi All

i have the same issue on sorting while using pagination, specifically sorting by id.
I tested it in all task, process instances and deployment queries. If i understand it correctly the id's in activiti are set as strings and sorting based on id gives improper results. Is there any reason why there is no check on <java> orderby***Id </java> methods to make sure that string is cast in to long or int before sorting then? i believe that would solve the issue.

is there any currently available way to resolve this?

- i did not include<java>includeProcessInstanceVariables </java> in my queries
- i am using activiti 5.19.0.1

Thank you

Re: Improper sorting when using pagination

jbarrez — Mon, 20 Jun 2016 13:02:19 GMT

> Is there any reason why there is no check on orderby***Id methods to make sure that string is cast in to long or int before sorting then? i believe that would solve the issue.

No, as this would need to be done on the database level. I'm not sure if this 1) is possible 2) is good for performance

What's the use case for sorting on id? Generally, there shouldn't be a real need for it as it's 'internal detail'.