Skip to main content

Setting The Precedence of Operators

Filters are applied from left to right. AND is applied before OR.

You can use parentheses in complex MQL WHERE clause to enforce or override the precedence of operators.

For example, to search for cash flow reports or equity reports in the PAYTRANS model, you can use the following MQL WHERE clause:
(semantic_search_text = '"cash flow" reports' OR semantic_search_text = 'equity reports') AND Model='PAYTRANS'.

The parentheses are necessary to allow the OR filters to be executed before the AND predicate.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!