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. |
Updated 25 days ago
Did this page help you?