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 >>