SmartListFilters
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 SmartListFilters WHERE SmartListId='3560'
Columns
Name | Type | Operators | Description |
Id [KEY] | Int | Id of the smart list filter. | |
SmartListId | Int | = | Id of the smart list. |
Name | String | The name of the smart list rule filter. | |
Operator | String | The operator used in the filter. | |
RuleType | String | The type of the rule. | |
RuleTypeId | Int | The Id of the rule type. | |
FilterMatchType | String | The rule filter match type | |
Conditions | String | JSON aggregate of smart list filter conditions. |