Condition Operators for Different Data Types

The operators available for defining a condition depends on the data type of the field for which you are defining the condition.

Table lists each data type and the operators available. In addition the Is Any operator means no condition is set.

Operators Available Different Data Types
Data Type Operators Description
String Is Returns the records in which the value of the field matches the string you type.
Contains Returns the records in which the value of the field contains the string you type.
Is Not Returns the records in which the value of the field does not match the string you type.
Starts With Returns the records in which the value of the field starts with the string you type.
Ends With Returns the records in which the value of the field ends with the string you type.
Is Null Returns the records in which the field has a null value.
Is Not Null Returns the records in which the field does not have a null value.
Integer, Long, Double Is Returns the records in which the value of the field matches the value you type.
Is Not Returns the records in which the value of the field does not match the value you type.
Is Greater Than Equal To Returns the records in which the value of the field is greater than or equal to the value you type.
Is Greater Than Returns the records in which the value of the field is greater than the value you type.
Is Less Than Equal To Returns the records in which the value of the field is less than or equal to the value you type.
Is Less Than Returns the records in which the value of the field is less than the value you type.
Is In The Range Returns the records in which the value of the field is in the range you provide.
Boolean True Returns the records in which the value of the field is true.
False Returns the records in which the value of the field is false.
DateTime Is Returns the records in which the value of the field matches the date and time you provide using the graphical controls.
Is Today Returns the records in which the value of the field is the current date.
Is Before Returns the records in which the value of the field is before the date and time you provide using the graphical controls.
Is After Returns the records in which the value of the field is after the date and time you provide using the graphical controls.
Is In The Last Returns the records in which the value of the field is from the last n time units you provide.

Note - Any records with future DateTime values display also. If this behavior is not desired, use the Is In The Range option instead, to limit the time range.

You can provide time in minutes, hours, days, months and years.
Is In The Range Returns the records in which the value of the field is within the range you provide using the graphical controls.
Is Null Returns the records in which the field has a null value.
Is Not Null Returns the records in which the field does not have a null value.