Action Search Filter Reference
Some action inputs support search filters (most panel source/BO fields, activities, contacts). Below is a list of search filters. Replace the word TERM with your search term. For operators that require two or more terms, replace TERM1, TERM2, etc.
For example, if you wanted to search for all e-mails matching a certain domain, you would enter: endsWith:@example.org
Search Filter | Applies To | Description |
---|---|---|
between:TERM1|TERM2 | number, date | ​Returns results where the field is between TERM1 and TERM2, inclusive. |
contains:TERM | string | Returns results where the field contains TERM. |
endsWith:TERM | string | Returns results where the field ends with TERM. |
equal:TERM eq:TERM | string, number, date | Returns results where the field exactly eqiuals TERM. |
greaterThan:TERM gt:TERM | number, date | Returns results where the field is greater than TERM. |
greaterThanOrEqual:TERM ge:TERM | number, date | Returns results where the field is greater than or equal to TERM. |
in:TERM1|TERM2|...|TERMN | string, number, date | Returns results where the field is equal to one of the TERMs in the specified list. NOTE: There is a limit to the number of fields that can be included in the list, based on the total size of the request URL / querystring value. |
isEmpty: empty: | any | Returns results where the field is empty or blank. NOTE: No term is required, but you must specify the search filter exactly as shown, including the trailing colon. |
isFalse: false: | boolean | Returns results where the boolean field is false. NOTE: No term is required, but you must specify the search filter exactly as shown, including the trailing colon. |
| boolean | Returns results where the boolean field is true. NOTE: No term is required, but you must specify the search filter exactly as shown, including the trailing colon. |
lessThan:TERM lt:TERM | number, date | Returns results where the field is less than TERM. |
lessThanOrEqual:TERM le:TERM | number, date | Returns results where the field is less than or equal to TERM. |
notContain:TERM !contain:TERM | string | Returns results where the field does not contain TERM. |
notEmpty: !empty: | any | Returns results where the field is not empty or blank. NOTE: No term is required, but you must specify the search filter exactly as shown, including the trailing colon. |
notEqual:TERM ne:TERM | string, number, date | Returns results where the field is not equal to TERM. |
startsWith:TERM | string | Returns results where the field starts with TERM. |