Activiti task query with variable result limit

vgaur — Sun, 10 Dec 2017 08:08:20 GMT

Hi Everyone,I am trying to fetch the all open tasks with variables from activiti engine using task query. I am using version 5.19.0.I see in TaskEntityManager.findTasksAndVariablesByQueryCriteria(), the max result is limited to 20000.Even if I try to fetch result in pages, this will still restrict m

Re: Activiti task query with variable result limit

Anonymous — Sun, 10 Dec 2017 10:40:25 GMT

Hi vgaur_.

I also encountered the same problem that cannot use sql paging with includeTaskLocalVariables・includeProcessVariables.
I solved this problem by the following pull request. This was merged in Activiti 5.22.0 version.
https://github.com/Activiti/Activiti/pull/891

With includeTaskLocalVariables・includeProcessVariables false, I divided into two queries.
1. First query get tasks.
2. Second query get variables by taskIds().
TaskService.getVariableInstancesLocalByTaskIds(Set<String> taskIds)
https://www.activiti.org/javadocs/org/activiti/engine/TaskService.html#getVariableInstancesLocalByTaskIds-java.util.Set-

topic Activiti task query with variable result limit in Alfresco Forum

Activiti task query with variable result limit

Re: Activiti task query with variable result limit