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 |