Returns an array of Price List Assignments matching a particular Customer Group and Price List and Channel.

Table Specific Information

Select

The driver uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

• Id supports the = comparison.
• CustomerGroupId supports the = and IN comparisons.
• PriceListId supports the = and IN comparisons.
• ChannelId supports the = and IN comparisons.

The rest of the filter is executed client-side within the driver.

SELECT * FROM PriceListAssignments WHERE CustomerGroupId IN (1, 2)

SELECT * FROM PriceListAssignments WHERE PriceListId IN (1, 2)

SELECT * FROM PriceListAssignments WHERE PriceListId = 1

SELECT * FROM PriceListAssignments WHERE CustomerGroupId = 1

Columns