Action search filter reference
Certain action inputs (including most panel sources and business object fields, activities, and contacts) support search filters. Replace the word TERM with the search term. For operators that require two or more terms, replace TERM1, TERM2, etc.
ExampleTo search for all emails matching a certain domain, enter:
endsWith:@example.org
Review the list below for common search filters:
| 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 equals *TERM*. Note: This is the default behavior, you do not need to specify the equal: operator explicitly. |
| 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. |
| isTrue: true: | 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*. |