Activiti task query with variable result limit

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

vgaur

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 me to 20k. 

Is there any way I can fetch task with variable after 20k record without using native sql.

Thanks

-Vishal

unknown

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-