Reference: Operators in Selectors

  • Updated

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

Was this article helpful?

2 out of 2 found this helpful