Discussions

Ask a Question
Back to all

Query interface — can one query combine condition groups with OR? e.g. (A = 1 AND B = 1) OR (A = 1 AND C = 2)

We access your platform's query APIs through our own backend gateway (a JSON/REST
BFF). For list-type queries we currently send flat equality filters and understand
these to be combined with AND (every supplied filter must match). We now have a
requirement to match a list by a boolean combination of two condition groups,
rather than a single flat AND list.

Question
Can the query interface support a single query equivalent to:

(A = 1 AND B = 1) OR (A = 1 AND C = 2)

that is: conditions grouped into sets, groups combined with OR, applied in one call?

(A, B, C are stand-ins for any filterable field — e.g. status / priority / category
on a work-order list. Our concern is the capability itself, so please treat them as
generic placeholders.)

If yes, please confirm:

  • The request payload structure to express OR groups (e.g. nested condition arrays
    with a per-level logic operator), and whether it applies to the work-order list
    query, all entity query endpoints, or only certain ones.
  • Any limits: maximum nesting depth, maximum number of conditions/groups per query,
    or expression-length constraints.

If no, what is the recommended pattern — e.g. issue one query per group and merge
results client-side, or is OR-nesting supported only in a different endpoint/API
version?

Thank you.