Sort and Filter Rules

Rule 1: Multiple Equality Filters (=) are Allowed
You can combine multiple filters using the equality (=) operator across different fields, as long as no inequality filters or sort orders are used.

Rule 2: Combining Filters with Inequalities or Sorting is Not Allowed
You cannot combine a filter on one field with an inequality filter (!=, >, <, >=, <=) or a sort order (SortField) on a different field. Such a query requires a specific database index that cannot be assumed to exist and will result in a “query too complex” error.

Rule 3: All Complex Operations Must Be on the Same Field
You can, however, use multiple inequality filters and a sort order if they all operate on the same field. Allowed Example: Find transactions with an Amount between 5000 and 10000, sorted by Amount.

"Filters": [
    {"Field": "Amount", "Operator": ">=", "Value": 5000},
    {"Field": "Amount", "Operator": "<=", "Value": 10000}
],
"SortField": "Amount",
"SortOrder": "asc"