Assignment Operators |
Assignment operators define the criteria that the filter uses to search fields in a database for specific values. Each condition statement in a filter must contain one assignment operator.
The following assignment operators are available when creating custom filters.
Option |
Description |
---|---|
Equals |
The value in the specified field must match the entered value. |
Does not equal |
The value in the specified field must not match the entered value. |
Is greater than |
The value in the specified field must be greater than the entered value. |
Is greater than or equal to |
The value in the specified field must be greater than or equal to the entered value. |
Is less than |
The value in the specified field must be less than the entered value. |
Is less than or equal to |
The value in the specified field must be less than or equal to the entered value. |
Is between |
The value in the specified field must be between the two entered values. |
Is not between |
The value in the specified field must not be between the two entered values. |
Is blank |
The specified field must not contain any data. |
Is not blank |
The specified field must contain data. |
Is any of |
The value in the specified field must be equal to any of the identified values. Click the icon to add additional values. |
Is none of |
The value in the specified field must not be equal to any of the identified values. Click the icon to add additional values. |
Begins with |
The value in the specified field must begin with the entered letter(s) or numbers(s). |
Ends with |
The value in the specified field must end with the entered letter(s) or numbers(s). |
Contains |
The value in the specified field must contain the entered string of letter(s) or numbers(s). |
Does not contain |
The value in the specified field must not contain the entered letter(s) or numbers(s). |
Is like |
The value in the specified field must be similar to the entered value. |
Is Not Like |
The value in the specified field must not be similar to the entered value. |