topic Re: taskService.createTaskQuery().or() in Alfresco Archive

taskService.createTaskQuery().or()

shiva_arunachal — Fri, 10 Apr 2015 09:34:25 GMT

Can you show the usage of or()‍ with an example since the javadoc seems to confuse me a bit.The javadoc for or() ‍method states the below:All query clauses called will be added to a single or-statement. This or-statement will be included with the other already existing clauses in the query, joined b

Re: taskService.createTaskQuery().or()

jbarrez — Tue, 14 Apr 2015 12:22:25 GMT

There are plenty examples in the source code in unit test.

But since I'm in such a good mood:

<code>
TaskQuery query = taskService.createTaskQuery().or().taskId(taskIds.get(0)).taskName("INVALID NAME").endOr();
</code>

Re: taskService.createTaskQuery().or()

shiva_arunachal — Wed, 15 Apr 2015 07:24:54 GMT

Thanks. It is clear now.. so it is basically like <code> (taskId(taskIds.get(0)) || taskName("INVALID NAME")) </code>.

Re: taskService.createTaskQuery().or()

jbarrez — Tue, 21 Apr 2015 08:03:04 GMT

Yup, that is correct

Re: taskService.createTaskQuery().or()

jonathan_amos — Tue, 30 Jun 2015 14:01:31 GMT

The syntax below does not work when i attempt to perform an or() search on 2 processvariables.

<java>
query = taskService.createTaskQuery().taskCandidateGroup(groupId).orderByExecutionId();
query = query.or().processVariableValueLike("subjectIDRegCenter", (String) taskCriteriaSearchObject.getTaskSearchValue()).processVariableValueLike("subject2IDRegCenter", (String) taskCriteriaSearchObject.getTaskSearchValue()).endOr();
query = asc ? query.asc() : query.desc();
return query.listPage(start, end);
</java>

Upon further inspection, i realize that queryVariableValues has a size of 1. I am unable to attach image from netbeans.

From the results returned, it seems to be performing an AND …not an OR.

So when value of subjectIDRegCenter and subject2IDRegCenter are the same, those results are the returned. But no results are returned when value of subjectIDRegCenter is different from subject2IDRegCenter. This defeats the purpose of the OR clause.

I would prefer not to use a nativequery. But if need be, i need some assistance/guidance on creating one.

Re: taskService.createTaskQuery().or()

jonathan_amos — Tue, 30 Jun 2015 15:13:02 GMT

I had to find some other way: I did this -

<java>
TaskQuery query = null;
TaskQuery query2 = null;
List<Task> tasks = new ArrayList<>();

query = taskService.createTaskQuery().taskCandidateGroup(groupId).orderByExecutionId();
query = query.processVariableValueEquals("subjectIDRegCenter", (String) taskCriteriaSearchObject.getTaskSearchValue());
query = asc ? query.asc() : query.desc();

query2 = taskService.createTaskQuery().taskCandidateGroup(groupId).orderByExecutionId();
query2 = query2.processVariableValueEquals("subject2IDRegCenter", (String) taskCriteriaSearchObject.getTaskSearchValue());
query2 = asc ? query2.asc() : query2.desc();

tasks = query.list();
tasks.addAll(query2.list());
return tasks;

</java>

The above works for me.
Using or() and concatenations performs AND queries.