Information
This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

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.

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*

AR System 21.05