CollectionRules
Returns a list of collection rules.
View-Specific Information
Select
The provider uses the Shopify API to process WHERE clause conditions built with the following column and operators. The provider processes other filters client-side within the provider.
- CollectionId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM CollectionRules WHERE CollectionId = 'Val1'
Columns
| Name | Type | References | Description |
| CollectionId | String |
Collections.Id | A globally-unique ID. |
| Column | String | The attribute that the rule focuses on.
The allowed values are IS_PRICE_REDUCED, PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_ID_WITH_DESCENDANTS, PRODUCT_METAFIELD_DEFINITION, PRODUCT_TAXONOMY_NODE_ID, TAG, TITLE, TYPE, VARIANT_COMPARE_AT_PRICE, VARIANT_INVENTORY, VARIANT_METAFIELD_DEFINITION, VARIANT_PRICE, VARIANT_TITLE, VARIANT_WEIGHT, VENDOR. | |
| Relation | String | The type of operator that the rule is based on.
The allowed values are CONTAINS, ENDS_WITH, EQUALS, GREATER_THAN, IS_NOT_SET, IS_SET, LESS_THAN, NOT_CONTAINS, NOT_EQUALS, STARTS_WITH. | |
| Condition | String | The value that the operator is applied to. | |
| ConditionObjectText | String | The text used as a rule for the condition. | |
| ConditionObjectTaxonomyCategoryId | String | The taxonomy category used as a rule for the condition. | |
| ConditionObjectProductTaxonomyId | String | The product category used as a rule for the condition. | |
| ConditionObjectMetafieldDefinitionId | String | The metafield definition used as a rule for the condition. |