SmartListFilterConditions
Query filters of smart lists in a Marketo organization.
Select
Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.
SELECT * FROM SmartListFilterConditions WHERE SmartListId='1093'
Columns
| Name | Type | Operators | Description |
| FilterId | Int | Id of the smart list filter. | |
| SmartListId | Int | = | Id of the smart list. |
| ActivityAttributeId | String | Id of activity attribute. | |
| ActivityAttributeName | String | Name of activity attribute. | |
| AttributeId | String | Id of attribute. | |
| AttributeName | String | Name of attribute. | |
| Operator | String | Value of operator. | |
| Values | String | List of values. | |
| IsPrimary | String | Whether the condition is primary or not (first condition of the smart list). | |
| IsError | String | Whether the condition is error. | |
| ErrorMessage | String | The error message if IsError=true. |