Selector operators define how Demandbase evaluates conditions to determine which records match your selector criteria. The available operators depend on the field type, such as date, integer, or string.
For example, you can use date operators to find accounts with recent activity, integer operators to filter accounts by Engagement Points, or string operators to match specific industries
Date Operators
Date operators allow you to filter records based on specific dates or relative timeframes.
Important: Demandbase records activities, journeys, and similar events using Coordinated Universal Time (UTC). The platform displays timestamps based on your web browser's local timezone. As a result, dates and times displayed in the UI may differ from the original UTC timestamps.
For example, when the date changes at 12:00 a.m. UTC, it is still 4:00 p.m. Pacific Standard Time (PST) on the previous day. You may need to adjust your date operators to account for timezone differences. See Understanding Demandbase Data Availability.
Date Operator |
Description |
|---|---|
| Equals | Matches the specified date. |
| Does Not Equal | Matches any date other than the specified date. |
| Before | Matches dates before the specified date. |
| After | Matches dates after the specified date. |
| Between | Matches dates within the specified date range. |
| In the Past | Matches dates within the specified timeframe in the past. |
| In the Past Before | Matches dates before the specified timeframe in the past. |
| In the Future | Matches dates within the specified timeframe in the future. |
| In the Future After | Matches dates after the specified timeframe in the future. |
| Exists | Matches records where the date field has a value. |
| Does Not Exist | Matches records where the date field has no value (NULL). |
| Yesterday | Matches the previous day. |
| Today | Matches the current day. |
| Tomorrow | Matches the following day. |
Integer Operators
Integer operators allow you to filter records based on numeric values, such as Engagement Points, employee count, or opportunity amount.
Integer Operator |
Description |
|---|---|
| Equals | Matches the specified number. |
| Does Not Equal | Matches any number other than the specified number. |
| Greater Than (>) | Matches numbers greater than the specified number. |
| Greater Than or Equal To (>=) | Matches numbers greater than or equal to the specified number. |
| Less Than (<) | Matches numbers less than the specified number. |
| Less Than or Equal To (<=) | Matches numbers less than or equal to the specified number. |
| Between | Matches numbers within the specified range. |
| Exists | Matches records where the numeric field has a value. |
| Does Not Exist | Matches records where the numeric field has no value (NULL). |
String Operators
String operators allow you to filter records based on text values, such as account name, industry, or account type.
String Operator |
Description |
|---|---|
| Contains | Matches text that includes the specified value. |
| Does Not Contain | Matches text that does not include the specified value. |
| Equals | Matches the specified text value exactly. |
| Does Not Equal | Matches any text value other than the specified value. |
| Begins With | Matches text that starts with the specified value. |
| Does Not Begin With | Matches text that does not start with the specified value. |
| Ends With | Matches text that ends with the specified value. |
| Does Not End With | Matches text that does not end with the specified value. |
| Exists | Matches records where the text field has a value. |
| Does Not Exist | Matches records where the text field has no value (NULL). |
Logic Operators
Logic operators allow you to combine multiple selector conditions to control which records qualify.
Logic Operator |
Description |
|---|---|
| AND | Matches records that meet all specified conditions. |
| OR | Matches records that meet at least one specified condition. |
| Comma (,) | Functions as OR when separating multiple values. |
Relationship Operators
Relationship operators allow you to filter records based on relationships between objects, such as accounts, people, and opportunities. See Understanding Relationship Selectors.
Relationship Operator |
Description |
|---|---|
| Any | Matches records with at least one qualifying relationship between objects. |
| No | Matches records with no qualifying relationships that meet the specified criteria. |
| At Least | Matches records with a number of qualifying relationships equal to or greater than the specified value. |
| Engagement Points | Filters accounts or people based on their total Engagement Points. |
| Pipeline Value | Filters based on the total pipeline value of related opportunities. |