Contents

Custom Filter Operators

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	Include accounts in the query results where the data matches the specified value.
Does not equal	Include accounts in the query results where the data does not match the specified value.
Less than	Include accounts in the query results where the data is less than the specified value. This operator is for date and numeric data types only.
Less than or equal To	Include accounts in the query results where the data is less than or equal to the specified value. This operator is for date and numeric data types only.
Greater than	Include accounts in the query results where the data is greater than the specified value. This operator is for date and numeric data types only.
Greater than or equal To	Include accounts in the query results where the data is greater than the specified value. This operator is for date and numeric data types only.
Like	Includes accounts in the query results where data matches the specified pattern. This operator is for alphanumeric data types only.
Matches Regular Expression	Includes accounts with data stored in the specified format. This operator is for alphanumeric data types only. ^[A-Z] finds all values in uppercase character format only. ^[a-z] finds all values in lowercase 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	Includes accounts in the query results where data starts with the specified character or characters. This operator is for alphanumeric data types only.
Contains	Includes accounts in the query results where data contains the specified character or characters. This operator is for alphanumeric data types only.
Ends with	Includes accounts in the query results where data ends with the specified character or characters. This operator is for alphanumeric data types only.
Does not start with	Includes accounts in the query results where data does not start with the specified character or characters. This operator is for alphanumeric data types only.
Does not contain	Includes accounts in the query results where data does not contain the specified character or characters. This operator is for alphanumeric data types only.
Does not end with	Includes accounts in the query results where data does not end with the specified character or characters. This operator is for alphanumeric data types only.
Does not match	Includes accounts in the query results where data does not match the specified character or characters. This operator is for alphanumeric data types only.
Not like	Includes accounts in the query results where data is not like the specified pattern. This operator is for alphanumeric data types only.