API V3 - search_criteria children
I'm trying to set up a search query using children in the search_criteria (as per the API guide ), however this throws a 4000 error on query. The query works fine if I split it in two and combine the results, however a single one would be better
- "list_info": {
- "row_count": "50",
- "search_criteria": [
- {
- "field": "site.name",
- "condition": "is",
- "logical_operator": "and",
- "values": [
- "Sydney","Melbourne","Singapore"
- ],
- "children": [
- {
- "field": "site",
- "logical_operator": "or",
- "condition": "is"
- }
- ]
- },
- {
- "field": "status.name",
- "logical_operator": "and",
- "condition": "is",
- "values": [
- "Open"
- ]
- },
- {
- "field": "technician",
- "logical_operator": "and",
- "condition": "is"
- }
-
- ]
- }
New to ADSelfService Plus?