topic Re: Count with OR(), processVariableValueEquals and taskAssignee in Alfresco Archive

Count with OR(), processVariableValueEquals and taskAssignee

hybaken — Mon, 02 Feb 2015 12:32:38 GMT

Hello,when I m using this filters on HistoricTaskInstanceQuery:.or().processVariableValueEquals("VarTest", "test").taskAssignee("test").endOr();and ask HistoricTaskInstanceQuery for count(), it returns incorrect number.Seems some join in HistoricTaskInstance.xml is not correct. I tried to used the s

Re: Count with OR(), processVariableValueEquals and taskAssignee

jbarrez — Mon, 09 Feb 2015 16:16:03 GMT

Hmmm sounds like a bug. A unit test that demonstrates this problem helps us to get it fixed quickly!

Re: Count with OR(), processVariableValueEquals and taskAssignee

soptik00 — Tue, 12 Jul 2016 07:46:02 GMT

Hi, I have the same issue. I used simple two conditions in OR. Returned list of HistoricTaskInstance is correct (for me is size 4). Only count is in this case wrong ( for me 140).
Will be this issue fixed in next version?

Thank for help.

<java>
query.or();
query.processVariableValueEquals(WorkflowProcessInstanceService.APPLICANT_USERNAME, loggedUsername);
query.processVariableValueEquals(WorkflowProcessInstanceService.IMPLEMENTER_USERNAME, loggedUsername);
//query.taskInvolvedUser(loggedUsername);
query.endOr();
</java>

Re: Count with OR(), processVariableValueEquals and taskAssignee

hybaken — Tue, 12 Jul 2016 10:11:20 GMT

I didn't have time to create unit test for it.

I don't know if it was fixed in higher version.

But I was able to find it quite easy in some xml file of ibatis/mybatis that are used in activiti as I remember. Unfortunately I do not have access to this code anymore. So I cant help you much. But in case it' s not fixed yet, you can find it there.