This article describes the profile operators available to you when you build criteria in queries, dynamic content, and programs. It also shows how the operators translate between building experiences.
Field data types
| Database and relational table field type | Data type |
|---|---|
| Text | |
| Text | Text |
| Yes / No | Text |
| Numeric | Numeric |
| Date | Date |
| Time | Text |
| Country | Text |
| Selection (choose one) | Text |
| Selection (multiple) | Text |
| Segmenting | Numeric |
| Phone number | Text |
| Timestamp | Date |
| Send hour | Numeric |
Note: Values are not case-sensitive.
Profile operators
| Operators used in the classic query builder and the query builder. | Operators in the classic rule builder for dynamic content, the rule builder for dynamic content, and program actions (These rules). |
|---|---|
| Date options | |
| Equals - the values are the same. | Is equal to - the values are the same. |
| Equals [Current Date] - the value is the current date. | Is today - the value is the current date. |
| Does not equal - the values are not the same. | Is not equal to - the values are not the same. |
| Less than - the date in the contact field is before the date entered, excluding the date entered. | Is before - the date in the contact field is before the date entered, excluding the date entered. |
| Less than [Current Date] - the date in the contact field is before the day that the query is executed. | Is before today - the date in the contact field is before the day that the query is executed. |
| Less than equals - the first value is less than or equal to the last value. | Is before - to make this operator equivalent to the classic operator, less than equals, you have to slide the date. For example, if you want less than equals for 07/9/2019, then use 07/10/2019 with is before. |
| Less than equals [Current Date] - the date in the contact field is either the day of or prior to the day that the query is executed. | Is not after today - the date in the contact field is either the day of or prior to the day that the query is executed. |
| Greater than - the date in the contact field is after the date entered, excluding the date entered. | Is after - the date in the contact field is after the date entered, excluding the date entered. |
| Greater than [Current Date] - the date in the contact field is after the day that the query is executed. | Is after today - the date in the contact field is after the day that the query is executed. |
| Greater than equals - the first value is greater than or equal to the last value. | Is after - to make this operator equivalent to the classic operator, greater than equals you have to slide the date. For example, if you want greater than equals for 07/09/2019, then use 07/08/2019 with is after. |
| Greater than equals [Current Date] - the date in the contact field is either the day of or after the day that the query is executed. | Is not before today - the date in the contact field is either the day of or after the day that the query is executed. |
| Is empty - there is nothing in the field. | Is blank - there is nothing in the field. |
| Is not empty- there is data in the field. | Is not blank - there is data in the field. |
| Is in the list - one of the named values is the same. | Is equal to one of the following - one of the named values is the same. |
| Is not in list - the information is not present in the list. Note: This operator ignores blanks. If you want blanks see the Operators and blanks in query builder, rule builder for dynamic content, and programs actions article. | Is not equal to one of the following - one of the named values is not the same. Note: This operator considers blanks. If you want blanks ignored, see the Operators and blanks in query builder, rule builder for dynamic content, and programs actions article. |
| Is between (a > ? < b) - the value is greater than the lesser value a but less than larger value b. | Is between (a > ? < b) - the value is greater than the lesser value a but less than larger value b. |
| Day is equal to - in the date entry mm/dd/yyyy, the dd value is the same as the value queried. Note: If the day is a single digit, a 0 must be entered in front of it to preserve a usable format. | Day is equal to - in the date entry mm/dd/yyyy, the dd value is the same as the value queried. Note: If the day is a single digit, a 0 must be entered in front of it to preserve a usable format. |
| Month is equal to - in the date entry mm/dd/yyyy, the mm value is the same as the value queried. Note: If the month is a single digit, a 0 must be entered in front of it to preserve a usable format. | Month is equal to - in the date entry mm/dd/yyyy, the mm value is the same as the value queried. Note: f the month is a single digit, a 0 must be entered in front of it to preserve a usable format. |
| Year is equal to - in the date entry mm/dd/yyyy, the yyyy value is the same as the value queried. | Year is equal to - in the date entry mm/dd/yyyy, the yyyy value is the same as the value queried. |
| Anniversary is equal to [Current Date] - this operator is helpful when building a campaign to wish contacts a happy birthday, happy wedding anniversary, or happy membership anniversary. The Anniversary criterion ignores the year. | Anniversary is today - this operator is helpful when building a campaign to wish contacts a happy birthday, happy wedding anniversary, or happy membership anniversary. The Anniversary criterion ignores the year. |
| N/A - Exclusive to the rule builder, does not exist for classic rule builder. | Anniversary is
|
| N/A - Exclusive to the rule builder, does not exist for classic rule builder. | Is within the last - the date in the contact field is matches the specified time into the past, including the day that the query is executed. Choices for the time span are days, weeks, or months. |
| N/A - Exclusive to rule builder, does not exist for classic rule builder. | Is not within the last - the date in the contact field does not match the specified time in the past, including the day that the query is executed. Note: Choices for the time span are days, weeks, or months. See for details. |
| N/A - Exclusive to the rule builder, does not exist for classic rule builder. | Is within the next - the date in the contact field matches the specified time into the future, including the day that the query is executed. Note: Choices for the time span are days, weeks, or months. See for details. |
| N/A - Exclusive to the rule builder, does not exist for classic rule builder. | Is not within the next - the date in the contact field does not match the specified time into the future, including the day that the query is executed. Note: Choices for the time span are days, weeks, or months. See for details. |
| N/A - Exclusive to rule builder, does not exist for classic rule builder. | Is exactly - the date in the contact field matches the date that is calculated from the user inputs. For example, is exactly 3 days ago is the date the query is executed minus three days. Note:
|
| N/A - Exclusive to the rule builder, does not exist for classic rule builder. | Is not exactly - the date in the contact field does not match the date that is calculated from the user inputs. So 'is not exactly 3 days ago' is the date the query is executed minus three days. Note:
|
| N/A - Exclusive to the rule builder, does not exist for classic rule builder. | Is within the last range of - the date in the contact field matches the user named range of time. So 'is within the last range of 5 to 7 days' is any date the query is executed minus 5, 6, or 7 days. Note: Choices for the time span are days, weeks, or months. See for details. |
| Difference - Determines the days between dates, and then creates a field depending on other criteria you set, such as being less than 6 months. | Within and Exactly can help with most of the things that Difference supports.
Is within the next - the date in the contact field matches the specified time into the future, including the date that the query is executed. Note: Choices for the time span are days, weeks, or months. See for details. Is exactly - the date in the contact field matches the date that is calculated from the user inputs. For example, is exactly 3 days ago is the date the query is executed minus three days. Note:
|
| Numeric options | |
| Equals - the values are the same. | Is equal to - the values are the same. |
| Does not equal - the values are not the same. | Is not equal to - the values are not the same. |
| Less than < - the first value is less than the last value. | Is less than - the first value is less than the last value. |
| Less than or equals (< =) - The first value is less than or equal to the last value. | Less than or equal to (< =) - the first value is less than or equal to the last value. |
| Greater than (>) - The first value is greater than the last value. | Is greater than (>) - The first value is greater than the last value. |
| Greater than or equals (> =) - The first value is greater than or equal to the last value. | Is greater than or equal to (> =) - The first value is greater than or equal to the last value. |
| Is empty - there is nothing in the field. | Is blank - there is nothing in the field. |
| Is not empty - here is data in the field. | Is not blank - there is data in the field. |
| Is in list - one of the named values is the same. | Is equal to one of the following - one of the named values is the same. |
| Is not in list - the information is not present in the list. Note: This operator ignores blanks. If you want blanks considered, see This operator ignores blanks. If you want blanks see the Operators and blanks in query builder, rule builder for dynamic content, and programs actions article. | Is not equal to one of the following - one of the named values is not the same. Note: This operator considers blanks. If you want blanks ignored, see This operator ignores blanks. If you want blanks see the Operators and blanks in query builder, rule builder for dynamic content, and programs actions article. |
| Is between - (a > ? < b) - the value is greater than the lesser value a but less than larger value b. | Is between (a > ? < b) - the value is greater than the lesser value a but less than larger value b. |
| Mod - Math function that can be set up in various ways (not the strict math definition). Mod primarily deals with the remainder after division, and for example, can create a list based on the remainder. This can be used for random sampling. | N/A (exclusive to classic rule builder, does not exist for rule builder) |
| Difference - determines the days between dates, and then creates a field depending on other criteria you set, such as being less than 6 months. | N/A (exclusive to classic rule builder, does not exist for rule builder) |
| Text options | |
| Equals - the values are the same. | Is equal to - the values are the same. |
| Does not equal - the values are not the same. | Is not equal to - the values are not the same. |
| Less than (<) - The first value is less than the last value. | N/A (exclusive to classic rule builder, does not exist for rule builder) |
| Less than or equals (< =) - The first value is less than or equal to the last value. | N/A (exclusive to classic rule builder, does not exist for rule builder) |
| Greater than (>) - The first value is greater than the last value. | N/A (exclusive to classic rule builder, does not exist for rule builder) |
| Greater than equals (> =) - the first value is greater than or equal to the last value. | N/A (exclusive to classic rule builder, does not exist for rule builder) |
| Is empty - there is nothing in the field. | Is blank - there is nothing in the field. |
| Is not empty - there is data in the field. | Is not blank - there is data in the field. |
| Is in list - one of the named values is the same. | Is equal to one of the following - one of the named values is the same. |
| Is not in list - the information is not present in the list. Note: This operator ignores blanks. If you want blanks considered, see This operator ignores blanks. If you want blanks see the Operators and blanks in query builder, rule builder for dynamic content, and programs actions article. | Is not equal to one of the following - One of the named values is not the same. Note: This operator considers blanks. If you want blanks ignored, see This operator ignores blanks. If you want blanks see the Operators and blanks in query builder, rule builder for dynamic content, and programs actions article. |
| Is between (a > ? < b) - the value is greater than the lesser value a but less than larger value b. | N/A - Exclusive to rule builder, does not exist for classic rule builder. |
| Contains - specified text is present. Example: red (one color of several possible colors: red, green, blue, orange ). | Contains - specified text is present. Example: red (one color of several possible colors: red, green, blue, orange). |
| Does not contain - specified text is not present. Example: red (one color of several possible colors: red, green, blue, orange).
Note: This operator ignores blanks. If you want blanks considered, see This operator ignores blanks. If you want blanks see the Operators and blanks in query builder, rule builder for dynamic content, and programs actions article. |
Does not contain - specified text is not present. Example: red (one color of several possible colors: red, green, blue, orange).
Note: This operator considers blanks. If you want blanks ignored, see This operator ignores blanks. If you want blanks see the Operators and blanks in query builder, rule builder for dynamic content, and programs actions article. |
| Starts with - a specified letter or specified text starts the field value. Example: Itinerary: (the letter I, or the word Itinerary) is present. | Starts with - a specified letter or specified text starts the field value. Example: Itinerary: (the letter I, or the word Itinerary) is present. |
| Does not start with - a specified letter or specified text does not start the field value.
Note: This operator ignores blanks. If you want blanks considered, see This operator ignores blanks. If you want blanks see the Operators and blanks in query builder, rule builder for dynamic content, and programs actions article.
|
Does not start with - a specified letter or specified text does not start the field value.
Note: This operator considers blanks. If you want blanks ignored, see This operator ignores blanks. If you want blanks see the Operators and blanks in query builder, rule builder for dynamic content, and programs actions article. |
| Ends with - a specified letter or specified text ends the field value. Example: (The letters ary, in the word Itinerary are present). | Ends with - a specified letter or specified text ends the field value. Example: (The letters ary, in the word Itinerary are present). |
| Does not end with - A specified letter or specified text does not end the field value.
Note: This operator ignores blanks. If you want blanks considered, see This operator ignores blanks. If you want blanks see the Operators and blanks in query builder, rule builder for dynamic content, and programs actions article. |
Does not end with - a specified letter or specified text does not end the field value.
Note: This operator considers blanks. If you want blanks ignored, see This operator ignores blanks. If you want blanks see the Operators and blanks in query builder, rule builder for dynamic content, and programs actions article. |
| N/A - Exclusive to rule builder, does not exist for classic rule builder. | Starts with one of the following - one of the named specified letters or specified text string starts the field value. |
| N/A - Exclusive to rule builder, does not exist for classic rule builder. | Does not start with one of the following - one of the named specified letters or specified text string does not start the field value. |
| N/A - Exclusive to rule builder, does not exist for classic rule builder. | Contains one of the following - the value in the field matches one of the named text values. |
| N/A - Exclusive to rule builder, does not exist for classic rule builder. | Does not contain one of the following - the value in the field does not match one of the named text values. |
Comments
0 comments
Please sign in to leave a comment.