Returns conditions associated with product complex rules.

Table-Specific Information

SELECT

The connector uses the BigCommerce API to process WHERE clause conditions built with the following column and operators. The rest of the filter is executed client-side within the connector.

• ProductId supports the = operator.

For example, the following queries are processed server-side:

SELECT * FROM ProductRuleConditions

SELECT * FROM ProductRuleConditions WHERE ProductId = 81

Columns

Name	Type	Description
RuleId [KEY]	Integer	The unique numeric ID of the rule with which the condition is associated.
ProductId [KEY]	Integer	The unique numeric ID of the product with which the rule is associated.
ModifierId [KEY]	Integer	The unique numeric ID of the modifier with which the rule condition is associated.
ModifierValueId	Integer	The unique numeric ID of the modifier value with which the rule condition is associated.
VariantId	Integer	The unique numeric ID of the variant with which the rule condition is associated.
CombinationId	Integer	The unique numeric ID of the SKU or combination with which the rule condition is associated.