Using both "and" and "or" operators with WorldServer Project Group Search API

I can see that the WorldServer REST API for Project Group Search supports an "operator" option. The UI sends "and" for the operator value. I've tried sending "or" from curl and it works too. 

Now I want to combine both operators, but it is not working for me.

For example OR works like below:

curl 'https://.../ws-api/v2/projectGroups/search?token=....' \
--header 'Content-Type: application/json' \
--data-raw '{"operator":"or","filters":[
{"field":"projects(workgroup)", "value": "TRANSIT", "operator": "like"},
{"field":"projects(workgroup)", "value": "HELP", "operator": "like"}
]}'


And an example for AND that also works:

curl 'https://.../ws-api/v2/projectGroups/search?token=....' \
--header 'Content-Type: application/json' \
--data-raw '{"operator":"and","filters":[
{"field":"projects(creationDate)","value":"2021-10-01T17:00:00+00:00,2021-10-31T17:00:00+00:00","operator":"between"}
{"field":"projects(workgroup)", "value": "HELP", "operator": "like"}
]}'

But a combined query using both AND and OR does not work:

curl 'https://.../ws-api/v2/projectGroups/search?token=....' \
--header 'Content-Type: application/json' \
--data-raw '{"operator":"and","filters":[
{"field":"projects(creationDate)","value":"2021-10-01T17:00:00+00:00,2021-10-31T17:00:00+00:00","operator":"between"},
{"field":"projects(workgroup)", "value": "TRANSIT", "operator": "like"},
{"operator":"or","filters":[{"field":"projects(workgroup)", "value": "HELP", "operator": "like"}]}
]}'

I would really appreciate any help for getting this query to work. Thanks.

Anuj

Parents Reply Children
No Data