SmartListRuleFilters
Query SmartLists rule filters
Table Specific Information
Select
Note: All filterable columns must be specified using the '=' operator. Atleast one of SmartListId, SmartCampaignId or ProgramId is required to get the Rule Filters.
Retrieve rule filters for Smart Lists by SmartListId
SELECT * FROM SmartListRuleFilters WHERE SmartListId = 1143 SELECT * FROM SmartListRuleFilters WHERE SmartListId IN (SELECT Id FROM SmartLists)
Retrieve rule filters for Smart Lists by SmartCampaignId
SELECT * FROM SmartListRuleFilters WHERE SmartCampaignId = 1682 SELECT * FROM SmartListRuleFilters WHERE SmartCampaignId IN (SELECT Id FROM SmartCampaigns)
Retrieve rule filters for Smart Lists by ProgramId
SELECT * FROM SmartListRuleFilters WHERE ProgramId = 1089 SELECT * FROM SmartListRuleFilters WHERE ProgramId IN (SELECT Id FROM SmartCampaigns)
Columns
| Name | Type | Filterable | Description |
| Id [KEY] | Integer | The Id of the smart list rule filter. | |
| 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 | Integer | The Id of the rule type. | |
| Conditions | String | The Rule filter conditions. | |
| FilterMatchType | String | The rule filter match type | |
| FilterCustomRuleLogic | String | The rule filter custom logic |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| SmartCampaignId | Integer | The Id of the smart campaign |
| ProgramId | Integer | The Id of the Program |
| SmartListId | Integer | The Smart List Id |