- Contents
Job Manager Help
Custom Filter Operations
The following table describes the operators that are available when setting custom filter criteria for query results. The operators available for a data item are based on the item's data type.
Operator |
Description |
Equals |
Retrieves accounts where the data matches the specified value. |
Does not equal |
Retrieves accounts where the data does not match the specified value. |
Less than |
Retrieves accounts where the data is less than the specified value. This operator is for date and numeric data types only. |
Less than or equal To |
Retrieves accounts where the data is less than or equal to the specified value. This operator is for date and numeric data types only. |
Greater than |
Retrieves accounts where the data is greater than the specified value. This operator is for date and numeric data types only. |
Greater than or equal To |
Retrieves accounts where the data is greater than the specified value. This operator is for date and numeric data types only. |
Like |
Retrieves accounts where data matches the specified pattern. This operator is for alphanumeric data types only. |
Matches Regular Expression |
Retrieves accounts where the system stores data in the specified format. This operator is for alphanumeric data types only. ^[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 |
Retrieves accounts where data starts with the specified character or characters. This operator is for alphanumeric data types only. |
Contains |
Retrieves accounts where data contains the specified character or characters. This operator is for alphanumeric data types only. |
Ends with |
Retrieves accounts where data ends with the specified character or characters. This operator is for alphanumeric data types only. |
Does not start with |
Retrieves accounts where data does not start with the specified character or characters. This operator is for alphanumeric data types only. |
Does not contain |
Retrieves accounts where data does not contain the specified character or characters. This operator is for alphanumeric data types only. |
Does not end with |
Retrieves accounts where data does not end with the specified character or characters. This operator is for alphanumeric data types only. |
Does not match |
Retrieves accounts where data does not match the specified character or characters. This operator is for alphanumeric data types only. |
Not like |
Retrieves accounts where data is not like the specified pattern. This operator is for alphanumeric data types only. |