- Contents
Liquid Latitude Help
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 |
|
Is equal to |
Include accounts in the query results where the data matches the specified value. |
|
Is not equal to |
Include accounts in the query results where the data does not match the specified value. |
|
Contains |
Includes accounts in the query results where data contains 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. |
|
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. |
|
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. |
|
Is null |
Includes accounts in the query results where the data contains no value. |
|
Is not null |
Includes accounts in the query results where the data contains any value. |
|
Is empty |
Includes accounts in the query results where the data is empty. |
|
Is not empty |
Includes accounts in the query results where the data is not empty. |
Related Topics
Create an Account Analysis Query