topic Re: How to query tasks matching more than one candidate group? in Alfresco Archive

How to query tasks matching more than one candidate group?

tstephen — Mon, 18 Apr 2011 06:02:13 GMT

Hi, Anyone able to suggest a way to do this without hitting the database for each candidate group and then having to merge and sort in memory? What I had in mind was something like: List<Task> tasks = processEngine.getTaskService().createTaskQuery().taskCandidateGroupIn("group1", "group2");‍Is

Re: How to query tasks matching more than one candidate group?

tstephen — Mon, 18 Apr 2011 12:36:03 GMT

I realised it may not have been clear that I want an OR semantic. In other words I'd like tasks that match any of the groups supplied not all.

I had a look through the code and it looks like someone else has been thinking in this direction already as the query selectTaskByQueryCriteriaSql in the Task.xml mapping file is already written to support more than one candidate group. Anyone object to me creating a JIRA to expose this in the TaskQuery interface?

Tim

Re: How to query tasks matching more than one candidate group?

frederikherema1 — Tue, 19 Apr 2011 09:02:47 GMT

Tim,

The multiple groups are used internally (when querying for task for which user is candidate). But I don't see a problem in exposing this in the query…

Re: How to query tasks matching more than one candidate group?

tstephen — Mon, 25 Apr 2011 05:09:41 GMT

I have created http://jira.codehaus.org/browse/ACT-796 and attached a patch to it.

Tim

Re: How to query tasks matching more than one candidate group?

nicolasfranck — Mon, 28 Apr 2014 06:53:34 GMT

Is this reflected anywhere in rest api?

something like:

POST query/process-instances

{
"candidateGroupIn": ["group1","group2"]
}

Re: How to query tasks matching more than one candidate group?

cmj — Tue, 14 Oct 2014 05:41:46 GMT

REST support should have been implemented in 5.16 (https://jira.codehaus.org/browse/ACT-2013), but it doesn't work for me in 5.16.3. In fact I didn't manage to query for multiple candidateGroups by any method:

GET http://localhost:8080/activiti-rest/service/runtime/tasks?candidateGroup=mygroup
=> works

GET http://localhost:8080/activiti-rest/service/runtime/tasks?candidateGroups=mygroup[,…]
=> seems to ignore the filter

POST http://localhost:8080/activiti-rest/service/query/tasks
{
"candidateGroupIn": ["group1", "group2"]
}
=> org.codehaus.jackson.map.exc.UnrecognizedPropertyException: Unrecognized field "candidateGroupIn" (Class org.activiti.rest.service.api.runtime.task.TaskQueryRequest), not marked as ignorable

Re: How to query tasks matching more than one candidate group?

jbarrez — Fri, 17 Oct 2014 10:04:30 GMT

Hmmm odd. The commit does contain a unit test for it: https://github.com/smirzai/Activiti/commit/59fcf446f11c52fe015b9fb21d61f72112642483

And it indeed seems to use the json approach for querying. From the code, i don't see anything wrong … but obviously it's not working for you. Can you see the difference between what you are doing and what is tested in the unit test?