API V3 - search_criteria children

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

  1. "list_info": {
  2.         "row_count": "50",
  3. "search_criteria": [
  4. {
  5. "field": "site.name",
  6. "condition": "is",
  7. "logical_operator": "and",
  8. "values": [
  9.   "Sydney","Melbourne","Singapore"
  10. ],
  11. "children": [
  12. {
  13. "field": "site",
  14. "logical_operator": "or",
  15. "condition": "is"
  16. }
  17. ]
  18. },
  19. {
  20. "field": "status.name",
  21. "logical_operator": "and",
  22. "condition": "is",
  23. "values": [
  24.   "Open"
  25. ]
  26. },
  27. {
  28. "field": "technician",
  29. "logical_operator": "and",
  30. "condition": "is"
  31. }
  32.         ]
  33. }

                  New to ADSelfService Plus?