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 Null	String, Date, Number	Checks whether the field is empty (contains no data).	Example 1: `Member Attributes` > `Email` > `Is Null` Example 2: `Purchase attributes` > `Notes` > `Is Null`
Is Not Null	String, Date, Number	Checks whether the field contains any value.	Example 1: `Member Attributes` > `Mobile` > `Is Not Null` Example 2: `Card Attributes` > `Card Number` > `Is Not Null`
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`
Exists	String, List of Strings	Checks whether the attribute key is in the data.	Example 1: `Member Attributes` > `External Id` > `Exists` Example 2: `Purchase attributes` > `Custom Field` > `Exists`
Not Exists	String, List of Strings	Checks whether the attribute key is not included in the data.	Example 1: `Member Attributes` > `Partner ID` > `Not Exists` Example 2: `Card Attributes` > `Legacy ID` > `Not Exists`

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`
Starts With	List of Strings	Checks whether the value begins with a specific prefix.	Example 1: `Purchase attributes` > `Item Code` > `Starts With` > `SKU` Example 2: `Member Attributes` > `Mobile` > `Starts With` > `+1`
Is Empty	String	Checks whether the field is empty (contains no data).	Example 1: `Member Attributes` > `Middle Name` > `Is Empty` Example 2: `Purchase attributes` > `Tender Notes` > `Is Empty`
Matches	String, List of Strings	Checks whether the value matches a specific regular expression pattern.	Example 1: `Member Attributes` > `First Name` > `Matches` > `^[A-Z]` Example 2: `Card Attributes` > `Vehicle Number` > `Matches` > `[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`
Not In	List of Strings	Checks whether the specific value isn't in the list.	Example 1: `Purchase attributes` > `Item Code` > `Not In` > `Restricted_01` Example 2: `Store Attributes` > `Code` > `Not In` > `Online_Store`
Is Valid Date	String	Checks whether a text string is in a valid date format.	Example 1: `Member Attributes` > `Passport Expiry String` > `Is Valid Date` Example 2: `Card Attributes` > `Activation String` > `Is Valid Date`

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	Number, List of Numbers	Checks whether the value is Checks whether the value is less than or equal to the specified value.	Example 1: `Member Attributes` > `Age` > `Greater Than Or Equal` > `18` Example 2: `Purchase attributes` > `Item Quantity` > `Greater Than Or Equal` > `2`
Less Than Or Equal	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` > `30` Example 2: `Purchase attributes` > `Discount` > `Less Than Or Equal` > `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`

Updated 1 day ago