AnsweredAssumed Answered

REST api OR/AND Predicate in Where Clause Iussue

Question asked by elainemarleyit on May 7, 2018

I use Alfresco 5.2 and i try retrive all my tasks using REST api.

My http request is this (like in documentation Using WHERE to restrict output | Alfresco Documentation )

"{{host]}/tasks?where=(assignee%3Dadmin)%20OR%20(candidateUser%3Dadmin)"

and response contains only tasks where admin is the assignee. If I reverse the positions of condition likeSome

"{{host]}/tasks?where=(candidateUser%3Dadmin)%20OR%20(assignee%3Dadmin)"

the response contains only the tasks where admin is a candidate.

The same with AND Predicate but if delete brackets and rewrite the request like

"{{host]}/tasks?where=(candidateUser%3Dadmin%20AND%20assignee%3Dadmin)"

it work fine with AND predicate ancd return an error with OR (04040001 An invalid WHERE query was received. Unsupported Predicate).

 

Any idea?Is there a solution?

 

 

Outcomes