- Contents
Exchange Manager Help
Custom Filter Operators
The following table describes the operators that are available when setting filter criteria. The operators available for a column are based on the column's data type.
|
Operator |
Description |
|
Equals |
Displays records where the value in the column matches the value that you specify. |
|
Does not equal |
Displays records where the value in the column does not match the value that you specify. |
|
Less than |
Displays records where the value in the column is less than the value that you specify. |
|
Less than or equal to |
Displays records where the value in the column is less than or equal to the value that you specify. |
|
Greater than |
Displays records where the value in the column is greater than the value that you specify. |
|
Greater than or equal to |
Displays records where the value in the column is greater than the value that you specify. |
|
Like |
Displays records where the value in the column matches the pattern that you specify. |
|
Matches Regular Expression |
Displays records where the value in the column is in the format that you specify.
^[A-Z] finds all values in uppercase character format only. ^[0-9] finds all values in numeric format only. ^[A-Za-z] finds all values in mixed case character format. ^[A-Za-z] finds all values in mixed case character format. ^[^0-9]+$ finds all values with a numeric format and dollar sign. ^[A-Za-z0-9] [A-Za-z0-9_]*$ finds all values of mixed case and currency. |
|
Starts with |
Displays records where the value in the column starts with the character or characters that you specify. |
|
Contains |
Displays records where the value in the column contains the character or characters that you specify. |
|
Ends with |
Displays records where the value in the column ends with the character or characters that you specify. |
|
Does not start with |
Displays records where the value in the column does not start with the character or characters that you specify. |
|
Does not contain |
Displays records where the value in the column does not contain the character or characters that you specify. |
|
Does not end with |
Displays records where the value in the column does not end with the character or characters that you specify. |
|
Does not match |
Displays records where the value in the column does not match the character or characters that you specify. |
|
Not like |
Displays records where the value in the column is not like the pattern that you specify. |