AnsweredAssumed Answered

Improper sorting when using pagination

Question asked by leggebroten on Jul 9, 2014
Latest reply on Jun 20, 2016 by jbarrez
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:
REST
   http://{{server}}/activiti-rest/service/runtime/tasks?excludeSubTasks=true&start=1&size=100&sort=dueDate&order=asc&taskDefinitionKey=myTask

Java
        TaskQuery taskQuery = taskService
                .createTaskQuery()
                .processDefinitionKey(processDefinitionKey)
                .taskDefinitionKey(taskDefinitionKey)
                .orderByDueDate().asc();
               
        List<Task> tasks = taskQuery.listPage(pageable.getOffset(), pageable.getPageSize());

Is my expectation wrong?  (Does this mean that if I want to do pagination I will have to get full result set back and do my own pagination)

Thanks in advance!

-Lee

Outcomes