Using relational operators in the advanced search bar

Relational operators are useful especially in non-text fields (such as date and time fields) when you want to search for a value within a numerical range. You can use the following relational operators only in the advanced search bar. You cannot use them in a form.

Related topics

Using relational operators in a search

Operators

Order of precedence for multiple operators

When you use multiple operators to construct qualification criteria, they are executed in the following order of precedence:

  1. ( )
  2. NOT (!) - (unary minus)
  3. ** / %*
  4. + -
  5. < <= > >= = != LIKE
  6. AND (&&)
  7. OR (||)

If the qualification contains multiple operators of the same precedence value, they are executed in the order that they occur (from left to right). For example, in the expression A + (B*C), the multiplication takes first precedence because it occurs within parentheses, which are of a higher precedence than addition.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*