topic Re: Tasks candidate group with assigned user in Alfresco Archive

Tasks candidate group with assigned user

aitor — Thu, 10 Oct 2013 09:11:46 GMT

How I can get the list of tasks that have a candidate group regardless of whether the tasks are assigned user or not?The method activitiRule.getTaskService().CreateTaskQuery().TaskCandidateGroup("sales");‍ ignores the assigned tasks. In my application all users belonging to a group have read permiss

Re: Tasks candidate group with assigned user

aitor — Thu, 10 Oct 2013 10:03:33 GMT

OK, I solved the problem using createNativeTaskQuery().
I use Oracle database.

<code>
taskService.createNativeTaskQuery().sql("SELECT task.* FROM ACT_RU_TASK task, ACT_RU_IDENTITYLINK link WHERE task.ID_ = link.TASK_ID_ AND link.GROUP_ID_ IN(" + candidateGroupList + ")").list()
</code>

Where 'candidateGroupList' is a String variable containing the groups to search, separated by commas.

Good day.

Re: Tasks candidate group with assigned user

udayakumar_p — Tue, 28 Oct 2014 12:57:27 GMT

we can combine the list returned by,
<code>
taskService.createTaskQuery().taskAssignee(userId).list();
and
taskService.createTaskQuery().taskCandidateGroup(userGroup).list();
</code>
Is that make sense?

Re: Tasks candidate group with assigned user

hybaken — Thu, 20 Nov 2014 14:14:55 GMT

any non native query solution for taskCandidateGroupIn ?

Is there any way to get something like taskAssigneeIn(userList) ?