topic Re: Retrieving assigned-task candidate to a group in Alfresco Archive

Retrieving assigned-task candidate to a group

vlagorce — Mon, 21 May 2012 09:02:42 GMT

I need to find all the task assigned or not candidate to one or many groups.http://jira.codehaus.org/browse/ACT-1214As shown in Jira the sql statement explicitly exclude assigned task. Is there a way to workaround this issue.

Re: Retrieving assigned-task candidate to a group

faloan — Mon, 21 May 2012 09:15:05 GMT

I asked a closely related question a few days ago: http://forums.activiti.org/en/viewtopic.php?f=6&t=3965

No answers so far. It would be great if someone could reply to this.

Re: Retrieving assigned-task candidate to a group

vlagorce — Mon, 21 May 2012 09:25:30 GMT

Sorry I didn't make a new search in the forum since I post the case in JIRA.

It's more than closely related, we have the same need ; Vote for the issue.

Re: Retrieving assigned-task candidate to a group

vlagorce — Thu, 24 May 2012 11:43:15 GMT

As workaround I set a variableLocal associate to the assigned task and run a task query for the variable. In my case setting the """assigneeGroup""" is efficient.

taskService.setVariableLocal(String taskId, String variableName, Object value)
taskService.createTaskQuery().taskVariableValueEquals(String variableName, Object variableValue).list()

Re: Retrieving assigned-task candidate to a group

conics — Fri, 24 Jan 2014 06:01:23 GMT

I need to do exactly the same.

Re: Retrieving assigned-task candidate to a group

jbarrez — Tue, 28 Jan 2014 09:51:50 GMT

An alternative is always, if the API doesn't give what you need, to write a custom query: http://www.jorambarrez.be/blog/2014/01/17/execute-custom-sql-in-activiti/