Skip to content

Filter operators

Every operator by field type, and every relative date expression.

Field typeOperators
Text, email, phone, URL, text areaEquals, Does Not Equal, Is Empty, Starts With, Ends With, Contains, Does Not Contain
PicklistSame as text
Multi-select picklistEquals, Does Not Equal, Is Empty, Includes, Excludes
Number, currencyEquals, Does Not Equal, Is Empty, Greater Than, Less Than, Less Than or Equal, Greater Than or Equal, Between
PercentSame as number, without Between
Date, date/timeSame as number, including Between
TimeSame as number, without Between
CheckboxEquals, Does Not Equal
Lookup, ID, formulaEquals, Does Not Equal, Is Empty
LocationIs Within, Is Not Within. See Filter by distance from a location.
Operator or fieldValue
Is EmptyTrue matches empty fields, False matches filled ones. It checks for no value at all, not for a space.
CheckboxTrue or False.
BetweenFrom and To, both included. To must be larger than From. On a date/time field, only the date counts.
Picklist, lookupSeveral values: Equals matches any of them, Does Not Equal none of them. Each value shows as a pill.
Multi-select picklistIncludes and Excludes check single selected values; Equals and Does Not Equal compare the whole selection.
TextA list of values with Equals, Does Not Equal, Contains, Does Not Contain, Starts With, Ends With. See Match a list of text values.
Date, date/timeA calendar date or a relative date. See Relative dates.

Under a date value, select Use relative date. CAB accepts the relative date expressions of Salesforce, in upper or lower case:

PatternExamples
One dayYESTERDAY, TODAY, TOMORROW
A periodLAST WEEK, THIS MONTH, NEXT QUARTER, THIS FISCAL YEAR
The last or next n periodsLAST 30 DAYS, NEXT 2 WEEKS, LAST 4 FISCAL QUARTERS
n periods ago90 DAYS AGO, 2 FISCAL YEARS AGO

FISCAL follows the fiscal year in Salesforce Setup under Fiscal Year and works with quarters and years only. Between takes calendar dates only. For the full list, see Relative date values in the Salesforce Help.

Contains, Does Not Contain, Ends With, Does Not Equal, Excludes and Is Empty with False count as possibly non-selective: on very large objects, such a condition can make a run slow. CAB flags them in the diagnostics. See Diagnose an audience query.