Retrieving assigned-task candidate to a group

[vlagorce]

I need to find all the task assigned or not candidate to one or many groups.

http://jira.codehaus.org/browse/ACT-1214

As shown in Jira the sql statement explicitly exclude assigned task. Is there a way to workaround this issue.

[faloan]

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.

[vlagorce]

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.

[vlagorce]

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()

[conics]

I need to do exactly the same.

[jbarrez]

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/