Operators
Operators are the logic functions used to compare attributes against values when building qualifying conditions. They determine how the system checks a specific data point. The available operators are based on the data type of the attribute you are evaluating.
1. Standard Comparison Operators
Applicable to Strings, Dates, and Numbers.
| Operator | Data Type | Description | Examples |
|---|---|---|---|
| Equals | String, Date, Number | Checks whether the attribute matches the value exactly. | Example 1: Member Attributes > First Name > Equals > John Example 2: Purchase attributes > Gross Amount > Equals > 100.50 |
| Not Equals | String, Date, Number | Checks whether the attribute isn't equal to the specified value. | Example 1: Member Attributes > Slab Name > Not Equals > Gold Example 2: Store Attributes > Name > Not Equals > Main Street |
| Is set | String, Date, Number | Checks whether the field has a value. | Example 1: Member Attributes > Mobile > Is set Example 2: Card Attributes > Card Number > Is set |
| Is not set | String, Date, Number | Checks whether the field has no value. | Example 1: Member Attributes > Email > Is not set Example 2: Purchase attributes > Notes > Is not set |
| Is one of | String, List of Strings | Matches any single item in the list. | Example 1: Member Attributes > Tier > Is one of > Gold, Platinum Example 2: Purchase attributes > Tender Code > Is one of > CASH, VISA |
| Is none of | String, List of Strings | Matches only if the value isn't in the list. | Example 1: Member Attributes > Status > Is none of > Blocked, Fraud Example 2: Store Attributes > Code > Is none of > Store_001 |
| Previous Value | String | Checks what the value was before the change. | Example 1: Member Update attributes > Mobile > Previous Value > 9999999999 Example 2: Member Update attributes > Email > Previous Value > [email protected] |
| Previous Custom Field Value | String | Checks the value of a specific custom field before it was changed. | Example 1: Member Update attributes > Custom Field > Previous Custom Field Value > Standard Example 2: Member Update attributes > Tier > Previous Custom Field Value > Silver |
| Current Custom Field Value | String | Checks the value of a specific custom field after it has changed. | Example 1: Member Update attributes > Custom Field > Current Custom Field Value > Premium Example 2: Member Update attributes > Status > Current Custom Field Value > Active |
| Current Value | String | Checks the value after the change. | Example 1: Member Update attributes > Last Name > Current Value > Smith Example 2: Member Update attributes > Loyalty Type > Current Value > Loyal |
| Is set | String, List of Strings | Checks whether the attribute key is in the data. | Example 1: Member Attributes > External Id > Is set Example 2: Purchase attributes > Custom Field > Is set |
| Is not set | String, List of Strings | Checks whether the attribute key isn't in the data. | Example 1: Member Attributes > Partner ID > Is not set Example 2: Card Attributes > Legacy ID > Is not set |
2. Text and List Operators
Specific to String fields and List of Strings.
| Operator | Data Type | Description | Examples |
|---|---|---|---|
| Contains | String, List of Strings | Checks whether the text includes a specific sequence of letters. | Example 1: Member Attributes > Full Name > Contains > Smith Example 2: Purchase attributes > Item Description > Contains > Organic |
| Is empty | String | Checks whether the field has no value. | Example 1: Member Attributes > Middle Name > Is empty Example 2: Purchase attributes > Tender Notes > Is empty |
| Matches Regex | String, List of Strings | Checks whether the value matches a specific regular expression pattern. | Example 1: Member Attributes > First Name > Matches Regex > ^[A-Z] Example 2: Card Attributes > Vehicle Number > Matches Regex > [0-9]{4} |
| Matches any of | List of Strings | Checks whether at least one item in a list matches the criteria. | Example 1: Purchase attributes > Item Code > Matches any of > Milk, Bread Example 2: Purchase attributes > Tender Code > Matches any of > VISA, AMEX |
| Matches all of | List of Strings | Checks whether every item in the list matches the criteria. | Example 1: Purchase attributes > Item Code > Matches all of > ItemA, ItemB Example 2: Purchase attributes > Promotion Code > Matches all of > SALE10, APP5 |
| Is not in | List of Strings | Checks whether the specific value isn't in the list. | Example 1: Member Attributes > Belong To Segment > Is not in > <segment name> Example 2: Member Attributes > Communication Profile > Is not in > EMAIL |
| Is valid | String | Checks whether a text string is in a valid date format. | Example 1: Member Attributes > Passport Expiry String > Is valid Example 2: Card Attributes > Activation String > Is valid |
3. Numerical Operators
Specific to Real numbers, Integers, and List of Numbers.
| Operator | Data Type | Description | Examples |
|---|---|---|---|
| Greater than | Number, List of Numbers | Checks whether the value is greater than the specified value. | Example 1: Member Attributes > Current Points > Greater than > 1000 Example 2: Purchase attributes > Gross Amount > Greater than > 50 |
| Less than | Number, List of Numbers | Checks whether the value is less than the specified value. | Example 1: Member Attributes > Slab Number > Less than > 3 Example 2: Member Attributes > Number of Visits > Less than > 5 |
| Greater than or equal to | Number, List of Numbers | Checks whether the value is greater than or equal to the specified value. | Example 1: Member Attributes > Age > Greater than or equal to > 18 Example 2: Purchase attributes > Item Quantity > Greater than or equal to > 2 |
| Less than or equal to | Number, List of Numbers | Checks whether the value is less than or equal to the specified value. | Example 1: Member Attributes > Days Since Visit > Less than or equal to > 30 Example 2: Purchase attributes > Discount > Less than or equal to > 20 |
| Is between | Number, List of Numbers | Checks whether the value falls within a range (inclusive). | Example 1: Member Attributes > Age > Is between > 21, 35 Example 2: Purchase attributes > Run Time > Is between > 60, 120 |
| Interval | Number | Checks whether the number matches a specific interval. | Example 1: Member Attributes > Number of Visits > Interval > 5 Example 2: Purchase attributes > Gross Amount > Interval > 100 |
| Year | Number | Extracts the year from a date for numeric comparison. | Example 1: Purchase attributes > Date > Year > Equals > 2025 Example 2: Member Attributes > Birth Date > Year > Less Than > 2000 |
| Month | Number | Extracts the month (1-12) from a date. | Example 1: Purchase attributes > Date > Month > Equals > 12 Example 2: Member Attributes > Enrolment Date > Month > Is One Of > 6, 7, 8 |
| Day | Number | Extracts the day of the week or the numeric day. | Example 1: Purchase attributes > Date > Day > Equals > 15 Example 2: Member Attributes > Join Date > Day > Is Not > 1 |
4. Date Operators
Specific to Date fields.
| Operator | Data Type | Description | Examples |
|---|---|---|---|
| Is | Date | Checks whether the date falls on a specific unit, for example, weekend). | Example 1: Purchase attributes > Date > Is > Weekend Example 2: Purchase attributes > Date > Is > Day |
| Is Not | Date | Checks whether the date doesn't fall on a specific unit. | Example 1: Purchase attributes > Date > Is Not > Weekend Example 2: Purchase attributes > Date > Is Not > Weekday |
| Is Before | Date | Checks whether the date is earlier. | Example 1: Member Attributes > Join Date > Is Before > 2024-01-01 Example 2: Card Attributes > Expiry Date > Is Before > 2025-12-31 |
| Is After | Date | Checks whether the date is later. | Example 1: Purchase attributes > Date > Is After > 2024-01-01 Example 2: Member Attributes > Last Login > Is After > 2025-02-01 |
| Is On Or Before | Date | Checks whether the date is on or before a specified date. | Example 1: Purchase attributes > Date > Is On Or Before > 2024-12-31 Example 2: Member Attributes > Slab Expiry > Is On Or Before > 2025-06-30 |
| Is On Or After | Date | Checks whether the date is on or after a specified date. | Example 1: Purchase attributes > Date > Is On Or After > 2025-01-01 Example 2: Card Attributes > Start Date > Is On Or After > 2023-01-01 |
| Is Time Between | Date | Checks whether the time is between the specified times. | Example 1: Purchase attributes > Date > Is Time Between > 12:00, 14:00 Example 2: Purchase attributes > Date > Is Time Between > 06:00, 09:00 |
| Is Hour Between | Date | Checks whether the hour is from 0 through 23. | Example 1: Purchase attributes > Date > Is Hour Between > 12, 14 Example 2: Purchase attributes > Date > Is Hour Between > 17, 22 |
| Is Valid | Date | Checks whether the date is a valid date object. | Example 1: Member Attributes > Birth Date > Is Valid Example 2: Card Attributes > Activation Date > Is Valid |
| Day Of Month | Date | Checks whether the day of the month is from 1 through 31. | Example 1: Purchase attributes > Date > Day Of Month > 1 Example 2: Member Attributes > Join Date > Day Of Month > 15 |
| Days Diff | Date | Calculates the count of days between two dates. | Example 1: Purchase attributes > Date > Days Diff > Member Attributes.Join Date Example 2: Card Attributes > Expiry Date > Days Diff > Current Date |
| Date Diff | Date | Calculates the absolute difference between two dates. | Example 1: Purchase attributes > Date > Date Diff > Member Attributes.Join Date Example 2: Redemption attributes > Date > Date Diff > Purchase attributes.Date |
| Minutes Diff | Date | Calculates the number of minutes between two dates. | Example 1: Purchase attributes > Date > Minutes Diff > 30 Example 2: Purchase attributes > Show Time > Minutes Diff > 15 |
| Is Before (TZ) | Date | Checks whether a date is earlier than a specified date in a specific time zone. | Example 1: Purchase attributes > Date > Is Before With Timezone > Asia/Kolkata Example 2: Member Attributes > Event Date > Is Before With Timezone > GMT |
5. Partner Program Specific Operators
| Operator | Data Type | What it Means | Examples |
|---|---|---|---|
| Partner Program Type | String (Enum) | Filters by the partner program type (for example, External or Supplementary. | Example 1: Partner attributes > Partner Program Type > Equals > EXTERNAL Example 2: Partner attributes > Partner Program Type > Is Not > SUPPLEMENTARY |
| Partner Tier Name | String | Matches the specific tier level assigned by the partner. | Example 1: Partner attributes > Partner Tier Name > Equals > Platinum Example 2: Partner attributes > Partner Tier Name > Is One Of > Level 1, Level 2 |
| Partner Program Update Type | String (Enum) | Checks the reason for a tier change (Upgrade, Downgrade, or Renew). | Example 1: Partner attributes > Update Type > Equals > UPGRADE Example 2: Partner attributes > Update Type > Is None Of > DOWNGRADE |
6. Event Attribute Operators
| Operator | Data Type | What it Means | Examples |
|---|---|---|---|
| Card Status | Boolean | Checks whether the card associated with the event is in a specific state. | Example 1: Event attributes > Card Status > Equals > Active Example 2: Registration attributes > Card Status > Not Equals > Expired |
| Card Series Name | Boolean | Checks whether the card belongs to a specific named series. | Example 1: Event attributes > Card Series Name > Contains > Elite Example 2: Redemption attributes > Card Series Name > Is One Of > Default, Promo |
| Promotion Identifiers Includes | Boolean | Checks whether the event is linked to specific internal promotion IDs. | Example 1: Event attributes > Promotion Identifiers > Contains > SUMMER_24 Example 2: Purchase attributes > Promotion Identifiers > Exists |