topic Bug with TaskQuery.taskCandidateOrAssigned? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/bug-with-taskquery-taskcandidateorassigned/m-p/230382#M183512 <HTML><HEAD></HEAD><BODY><SPAN>I'm seeing some behavior with using TaskQuery.taskCandidateOrAssigned that seems like a bug but wanted to check before opening an issue.</SPAN><BR /><BR /><SPAN>I have a process with two different user tasks, one called Manager with a candidate group manager and another called Review with no candidate group.&nbsp; I have my own GroupEntityManager that implements the findGroupsByUser method and it is being called and working fine in most cases to get the groups for a user and return the right thing when using TaskQuery.taskCandidateUser for example.</SPAN><BR /><BR /><SPAN>Here is the scenario.</SPAN><BR /><BR /><SPAN>Two process instances are created that are at the Manager user task.&nbsp; One is assigned to user john and the other is unassigned.&nbsp; Additionally, there is a process instance at the Review task and it is assigned to andy.</SPAN><BR /><BR /><SPAN>Using taskCandidateUser with user andy returns the unassigned Manager task which is correct.&nbsp; It does not return the task assigned to john nor the Review task assigned to andy.</SPAN><BR /><BR /><SPAN>However, if I use taskCandidateOrAssigned instead, just the Review task is returned.&nbsp; I would expect this to still return the unassigned task as it is a candidate.</SPAN><BR /><BR /><SPAN>Looking at the code, specifically Task.xml, it appears for the taskCandidateUser case, the SQL generated includes something like this which uses the candidateGroups retrieved from my GroupEntityManager:</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="candidateGroups != null &amp;amp;&amp;amp; candidateGroups.size() &amp;gt; 0"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I.GROUP_ID_ IN</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;foreach item="group" index="index" collection="candidateGroups"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; open="(" separator="," close=")"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #{group}</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/foreach&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;</SPAN><BR /><BR /><SPAN>But in the case of using taskCandidateOrAssigned it is not, instead it is only using the internal table with this:</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;if test="candidateGroups == null"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and (RES.ASSIGNEE_ = #{userIdForCandidateAndAssignee} or (RES.ASSIGNEE_ is null and (I.USER_ID_ = #{userIdForCandidateAndAssignee}</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; or I.GROUP_ID_ IN (select g.GROUP_ID_ from ${prefix}ACT_ID_MEMBERSHIP g where g.USER_ID_ = #{userIdForCandidateAndAssignee} ) ) ) )</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/if&gt;</SPAN><BR /><BR /><BR /><SPAN>This seems like a bug to me, what is returned from taskCandidateOrAssigned should include everything returned from taskCandidateUser plus any assigned, and it shouldn't matter if a custom GroupEntityManager is used or not.</SPAN><BR /><BR /><SPAN>Please confirm and let me know if I need to open an issue.</SPAN><BR /><BR /><SPAN>Note, I'm using 5.19.0.2.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>Kevin</SPAN><BR /><BR /></BODY></HTML> Tue, 15 Mar 2016 16:58:13 GMT schmke 2016-03-15T16:58:13Z Bug with TaskQuery.taskCandidateOrAssigned? https://connect.hyland.com/t5/alfresco-archive/bug-with-taskquery-taskcandidateorassigned/m-p/230382#M183512 I'm seeing some behavior with using TaskQuery.taskCandidateOrAssigned that seems like a bug but wanted to check before opening an issue.I have a process with two different user tasks, one called Manager with a candidate group manager and another called Review with no candidate group.&nbsp; I have my own Tue, 15 Mar 2016 16:58:13 GMT https://connect.hyland.com/t5/alfresco-archive/bug-with-taskquery-taskcandidateorassigned/m-p/230382#M183512 schmke 2016-03-15T16:58:13Z Re: Bug with TaskQuery.taskCandidateOrAssigned? https://connect.hyland.com/t5/alfresco-archive/bug-with-taskquery-taskcandidateorassigned/m-p/230383#M183513 <HTML><HEAD></HEAD><BODY><SPAN>I'm assuming this is yours: </SPAN><A href="https://github.com/Activiti/Activiti/pull/846" rel="nofollow noopener noreferrer">https://github.com/Activiti/Activiti/pull/846</A><SPAN>? We'll discuss further there (but give us a couple of days, lots of PR's to process!)</SPAN></BODY></HTML> Fri, 18 Mar 2016 13:27:36 GMT https://connect.hyland.com/t5/alfresco-archive/bug-with-taskquery-taskcandidateorassigned/m-p/230383#M183513 jbarrez 2016-03-18T13:27:36Z Re: Bug with TaskQuery.taskCandidateOrAssigned? https://connect.hyland.com/t5/alfresco-archive/bug-with-taskquery-taskcandidateorassigned/m-p/230384#M183514 <HTML><HEAD></HEAD><BODY><SPAN>Yep, that is it.&nbsp; Thanks for taking a look.</SPAN></BODY></HTML> Fri, 18 Mar 2016 13:29:54 GMT https://connect.hyland.com/t5/alfresco-archive/bug-with-taskquery-taskcandidateorassigned/m-p/230384#M183514 schmke 2016-03-18T13:29:54Z