7.1 Comparison Operators

Open the 'Ad Hoc' report. Right-click on a table and choose 'Filtering'.

Multiple conditions can be added by using 'AND' or 'OR' logical operators.
Table 3. List of Comparison Operators.
equal to |
It equates two entities. |
one of |
Checks if the value is a member of a list. Values can be entered one at a time, or comma separated. |
less than |
Less than numerically, earlier date, etc. |
greater than |
Greater than numerically, later date, etc. |
between |
Checks if the value is in a range. |
starting with |
Checks the beginning of a string. |
contains |
Checks if the value contains a substring. |
null |
Checks if the value is null. |
| << 7 Filtering | © 1996-2013 InetSoft Technology Corporation (v11.5) | 7.2 Create Expression >> |