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 topic

Using relational operators in a search

Order of precedence for multiple operators

When you use multiple operators to construct a 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*