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 |