Using operators with Selectors lets you get very specific about what you want the Selector to return. For example, you can find accounts where the annual revenue for the account is greater than $1,500,000. The type of operators you can use differ depending on the type of field used in the Selector.
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 |
Important: When using date operators, keep in mind that Demandbase sets the timestamp of an activity, journey, etc., based on Coordinated Universal Time (UTC). In the Demandbase platform, the timestamp is converted to the localized timezone of your web browser. This can represent a difference in hours between the Demandbase timestamp and the timezone of your web browser. For example, when the date changes at 0:00 UTC, the time in PST is still 16:00 of the previous day. You may want to adjust date operators accordingly.
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 |