topic Re: Some questions in Task query? in Alfresco Archive

Some questions in Task query?

bojiang — Tue, 15 Mar 2011 11:21:52 GMT

Hi When I want to query tasks ,I use TaskQuery to add some criteria. I want to query all the tasks that a user can do ,including tasks assigned to this user , and tasks can be pulled by this user. I use the below code to do this query. pe.getTaskService().createTaskQuery().taskAssignee("life"

Re: Some questions in Task query?

frederikherema1 — Wed, 16 Mar 2011 10:27:53 GMT

Hi,

1) When asking for taskAssignee and candidate in the same query, you get the contradicting T.ASSIGNEE_ clauses. This is because the candidate user/group excludes all tasks that are already assigned.

2) You can use the TaskQuery.taskVariableValueEquals (and in 5.4, also processVariableValueEquals) for this. Per variable you query, a extra join will be made in DB.

Re: Some questions in Task query?

bojiang — Thu, 17 Mar 2011 08:45:28 GMT

Hi,

1) When asking for taskAssignee and candidate in the same query, you get the contradicting T.ASSIGNEE_ clauses. This is because the candidate user/group excludes all tasks that are already assigned.

2) You can use the TaskQuery.taskVariableValueEquals (and in 5.4, also processVariableValueEquals) for this. Per variable you query, a extra join will be made in DB.

Thanks for your reply, I'm using version 5.1.
My suggestion is that if there's a heavy query interface that can combine all the runtime tables by different search criterias.
For example , one user log on system, open the work list page, and just one query to list all the tasks that he can do ,including tasks assigned to him,and tasks not assigned but have this user in their coordinate users. Also, this query can combine variable based search.

Re: Some questions in Task query?

jbarrez — Mon, 21 Mar 2011 16:36:22 GMT

Such a query is not yet possible wioth the public API, but you can of course always write the query yourself if it is really not possible to do it in-mem.