topic Re: Howto get both assigned tasks and tasks where use is candidate in one call in Alfresco Archive

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

xman-berlin — Fri, 25 Apr 2014 13:48:06 GMT

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 worktart one process with one simple user task defining candidate groups (group1, group2)Query tasks for user (member

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

martin_grofcik — Mon, 28 Apr 2014 07:04:45 GMT

Hi Torsten,

e.g.


…
    TaskQuery query = taskService.createTaskQuery().taskCandidateOrAssigned("kermit");
…

task candidate in groups


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

Regards
Martin

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

xman-berlin — Mon, 28 Apr 2014 07:15:32 GMT

Hi Martin,

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

Thanks,
Torsten

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

xman-berlin — Mon, 28 Apr 2014 07:36:24 GMT

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

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

martin_grofcik — Tue, 29 Apr 2014 07:12:47 GMT

Hi Torsten,

I created jUnit test and you are right.

The way how the query is implemented is:


        <when test="bothCandidateAndAssigned">
          <if test="userIdForCandidateAndAssignee != null">
            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} ) ) )
          </if>
        </when>

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

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

xman-berlin — Tue, 29 Apr 2014 12:31:45 GMT

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

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

martin_grofcik — Wed, 30 Apr 2014 06:16:48 GMT

Hi Torsten,

I would say, that limitation is


RES.ASSIGNEE_ is null …..

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

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

p4w3l — Mon, 17 Aug 2015 08:38:20 GMT

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

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

bam — Thu, 04 Feb 2016 16:07:40 GMT

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.

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

bam — Thu, 04 Feb 2016 17:53:16 GMT

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.

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

trademak — Thu, 04 Feb 2016 19:52:04 GMT

Hi,

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

Best regards,

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

schmke — Sat, 12 Mar 2016 01:43:30 GMT

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