topic Re: Query task that assigned to me or candidate group I member in Alfresco Archive

Query task that assigned to me or candidate group I member

bekesizoltan — Tue, 14 Feb 2012 22:33:52 GMT

Hi,I would like to show all the task (paged and ordered) that is assigned to me or the task is at a candidate group that I a member of.I can do task query only for one case , but it would be great to merge the 2 kind (assigned to me, one of my groups is the candidate group results into one grid) of

Re: Query task that assigned to me or candidate group I member

tstephen — Wed, 15 Feb 2012 13:20:57 GMT

To query for tasks in more than one group at a time you need the patch attached to http://jira.codehaus.org/browse/ACT-796. The latest comment is that this should be in 5.9 (not yet released).

Once you have that I believe it is possible to combine assignee and candidateIn something like this:

List<Task> tasks = processEngine.getTaskService().createTaskQuery().taskAssignee("user").taskCandidateGroupIn("group1", "group2");

Hope this helps,
Tim

Re: Query task that assigned to me or candidate group I member

bekesizoltan — Mon, 20 Feb 2012 21:24:59 GMT

Hi,

At the end, today, I edited the org/activiti/db/mapping/Task.xml to deal with 3 different options:
1, taskAssignee is defined, and no candidate user and no candidate group
2, no taskAssignee is defined and (candidate user or group is defined)
3, both defined ( I used here left outer join to have all the results)

Regards,
Zotlan

To query for tasks in more than one group at a time you need the patch attached to http://jira.codehaus.org/browse/ACT-796. The latest comment is that this should be in 5.9 (not yet released).

Once you have that I believe it is possible to combine assignee and candidateIn something like this:
List<Task> tasks = processEngine.getTaskService().createTaskQuery().taskAssignee("user").taskCandidateGroupIn("group1", "group2");
Hope this helps,
Tim