topic Querying tasks for process variable values for single variable results in lots of joins in Alfresco Archive

Querying tasks for process variable values for single variable results in lots of joins

shailendra1 — Fri, 16 May 2014 09:23:37 GMT

Hi All,I am using TaskQuery to find tasks which belong to processes having certain set of possible process variable values for a single variableFor e.g.,TaskQuery query = taskService.createTaskQuery();query.processVariableValueEquals("a1", "value1");query.processVariableValueEquals("a1", "value2");

Re: Querying tasks for process variable values for single variable results in lots of joins

martin_grofcik — Mon, 19 May 2014 06:43:21 GMT

Hi,

If you can optimize the query by yourselves, you can use native query support.
http://www.activiti.org/userguide/#advanced.custom.sql.queries

Regards
Martin

Re: Querying tasks for process variable values for single variable results in lots of joins

shailendra1 — Wed, 21 May 2014 09:35:16 GMT

Thanks Martin. As of now I will be using native query.