Operators in Selectors

  • Updated

Operators are a part of Selectors that allow you to get very specific about what you want the Selector to return (for example, Find accounts where the annual revenue for the account is greater than $1,500,000). Operators will differ depending on the type of field used in the Selector.

When specifying dates in the selector operators, consider that the back end of Demandbase sets the timestamp of an activity, journey, etc., based on Coordinated Universal Time (UTC). This can represent a considerable difference in the number of hours from the localized time configured in Demandbase. For example, when the date changes at 0:00 UTC, the time in the PDT time zone is still 16:00 of the previous day. You might want to adjust operators that involve timeframes accordingly.

Date Operators Description
Equals Exact match on selected date
Does Not Equal Any date other than the selected date
Before Any date before the selected date
After Any date after the selected date
Between Any date between the selected date range
In the Past A date within the selected timeframe
In the Past Before Any date before the selected timeframe
In the Future Any date within the selected timeframe
In the Future After Any date after the selected timeframe
Exists Date field is not empty
Does Not Exist  Date is NULL
Yesterday

Day before today

Today Today
Tomorrow

Day after today

 

Integer Operators Description
Equals Exact match on number entered
Does Not Equal Any number except the exact match on the number entered
Greater Than (>) Numbers larger than the number entered
Greater Than or Equal To (>=) Exact match on the number entered and any larger number
Less Than (<) Numbers smaller than the number entered
Less Than or Equal To (<=) Exact match on the number entered and any smaller number
Between Numbers within the selected range
Exists Number field is not empty
Does Not Exist Number is NULL

 

String Operators Description

Contains

Any string that includes an exact match of text in the string 

Does Not Contain

Any string that does not include the exact match of text in the string

Equals

Exact match on string

Does Not Equal

Any string except the exact match on the string 

Begins With

Any string that starts with an exact match on the string 

Does Not Begin With

Any string that does not start with an exact match on the string 

Ends With

Any string that ends with an exact match on the string 

Does Not End With

Any string that does not end with an exact match on the string 

Exists

String is not empty

Does Not Exist

String is NULL

 

Logic Operators Description

And

Records that match all values

Or

Records that match at least one value

,

Or

Was this article helpful?

2 out of 2 found this helpful