topic Re: Fetching tasks for candidateUser in Alfresco Archive

Fetching tasks for candidateUser

vvstraet — Tue, 28 Aug 2012 12:42:22 GMT

Hello,A key feature in a workflow-driven application is the tasklist in which tasks can be queried based on certain filters. I'm struggling however with the TaskQuery API as a very common feature is very difficult to implement: Query for a list that contains all the tasks I may get on my todo-list.

Re: Fetching tasks for candidateUser

vvstraet — Mon, 24 Sep 2012 14:47:09 GMT

Maybe the question in my original post was not entirely clear:
Is there a way to achieve this - with sorting, paging, … - without having to modify the Activiti source code?

Re: Fetching tasks for candidateUser

jbarrez — Tue, 25 Sep 2012 08:55:21 GMT

I quickly checked the code, and it seems that taskInvolved should give you that semantics:


  /** Only select tasks for which there exist an {@link IdentityLink} with the given user */
  TaskQuery taskInvolvedUser(String involvedUser);

Did you try the combination of taskInvolved and assignee?

Re: Fetching tasks for candidateUser

p4w3l — Thu, 27 Sep 2012 12:48:34 GMT

I don't have an example with candidateUser but I have for candidateGroup. The bad thing is that none of below show potential task for 'user':
- single .taskInvolvedUser( userId )
- mixed .taskInvolvedUser( userId ) with .taskAssignee( userId )

The good thing is that single .taskCandidateUser( userId ) works GREAT even for candidateGroup only ( when assignee and cadidateUsers is empty and only candidateGroups is used with a group value )

Still not solved is to get a list that have all tasks userId assigned AND potential task at the same time.

Re: Fetching tasks for candidateUser

jbarrez — Mon, 01 Oct 2012 12:06:38 GMT

Nope, that won't be possible with the current API, because it uses 'and semantics'.

In 5.11, we've added a way to fire off 'native queries', which is what you'd probably need for your use case.

Re: Fetching tasks for candidateUser

vvstraet — Thu, 04 Oct 2012 07:33:17 GMT

Thanks for the replies. We've adapted the Task.xml for now, but will probably try the native query in 5.11 (when it's available).

Re: Fetching tasks for candidateUser

jbarrez — Fri, 05 Oct 2012 06:32:48 GMT

Check out https://jira.codehaus.org/browse/ACT-1395, I believe it is the same use case as yours.

Re: Fetching tasks for candidateUser

heymjo — Fri, 05 Oct 2012 10:18:14 GMT

we need this as well, vvstraet care to share your modification to Task.xml for this ?

Re: Fetching tasks for candidateUser

sunilkumartk — Sat, 23 Apr 2016 03:04:26 GMT

in version 5.19
i think this is still an issue.

i tried
taskService.createTaskQuery()
                            .taskCandidateGroup("techassessment")
                            .includeProcessVariables()
                            .list();

as I have NOT used .taskUnassigned(), it should have returned everything. It doesnt!!
I think it should have returned everything as default and only unassigned when taskUnassigned is used.

i tried using the Native Query also but i am unable to add process Variables data with it..