nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Howto get both assigned tasks and tasks where use is candidate in one call

xman-berlin

Hi all,

I want to retrieve all tasks that are assigned to a user plus all tasks where the user is a candidate to properly implement paging and sorting. The following scenario should work:

Start one process with one simple user task defining candidate groups (group1, group2)
Query tasks for user (member of group1) for assigned and candidate tasks: returns the simple unassigned task
User claims that task
Query tasks for user (member of group1) for assigned and candidate tasks: returns the simple assigned task

I tried different combinations of TaskQuery-Parameters, e.g. taskAssignee+candidateUser or assignee+candidateGroupIn, but the resulting list did not contain the assigned task.

Any help is appreciated,
Best regards,
Torsten

Find more posts tagged with

Comments

martin_grofcik

Hi Torsten,

e.g.

<br>&hellip;<br>&nbsp;&nbsp;&nbsp; TaskQuery query = taskService.createTaskQuery().taskCandidateOrAssigned("kermit");<br>&hellip;<br>

task candidate in groups

<br>&nbsp;&nbsp;&nbsp; List<String> groups = Arrays.asList("management", "accountancy");<br>&nbsp;&nbsp;&nbsp; TaskQuery query = taskService.createTaskQuery().taskCandidateGroupIn(groups);<br>

Regards
Martin

xman-berlin

Hi Martin,

this works. I thought I already tested it, but obviously not.

Thanks,
Torsten

xman-berlin

Follow up: The function seems to fail for users which were candidates as well. I have the following test case:

Start process with a simple task.
user1 and user2 are candidates of the task.
user1 claims the task.
user1 queries tasks by TaskQuery.taskCandidateOrAssigned: returns task1. -> OK
user2 queries tasks by TaskQuery.taskCandidateOrAssigned: returns task1. -> FAIL.

I thought that claiming a task removes it from tasklist of other candidates. To prove the failure, I tried to claim the task by user2 but this works as expected -> Activiti throws ActivitiTaskAlreadyClaimedException.

Any hints?

Thanks,
Torsten

martin_grofcik

Hi Torsten,

I created jUnit test and you are right.

The way how the query is implemented is:

<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <when test="bothCandidateAndAssigned"><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <if test="userIdForCandidateAndAssignee != null"><br>&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} or I.GROUP_ID_ IN (select g.GROUP_ID_ from ACT_ID_MEMBERSHIP g where g.USER_ID_ = #{userIdForCandidateAndAssignee} ) ) )<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </if><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </when><br>

It means that candidate is taken into account only for tasks without assignee.
Another possibility for you could be to use native query support.

Regards
Martin

xman-berlin

Hi Martin,

I see, the sql statement is just missing the limitation of "RES_ASSIGNEE_ is null" when it checks the group IDs.

I think this is a bug.

Thanks for your help,
Torsten

martin_grofcik

Hi Torsten,

I would say, that limitation is
<br>RES.ASSIGNEE_ is null …..<br>
I think when the task is assigned, it is not fetched into the query for candidates.

I am not sure whether it is bug or not, it could be done by purpose like this.

Regards
Martin

p4w3l

Can you please give a native query solution for the original question: Howto get both assigned tasks and tasks where use is candidate in one call

bam

Hello,

I think that the option "RES.ASSIGNEE_ is null" should be an option in the API of the task query.
I have a similar need, and i'm struggling with it. I see no other choice than native query, which isn't nice..

Or, is there any other way?

Thanks,
Regards.

bam

Please, please, create an option for that use case. We might want to see our tasks and our colleague's !
I forked the repo to edit Task.xml to remove all the references to "RES.ASSIGNEE_ is null", and recompile my own version of the engine. I hate doing this. I hate it..

Thank you.

trademak

Hi,

The best way to get this in the Activiti project is to create a pull request.

Best regards,

schmke

Was anything done about this request? I think this is the same thing I was asking about in another thread: https://forums.activiti.org/content/how-get-tasks-where-user-would-be-candidate-if-not-already-assigned