Query order item properties.

View-Specific Information

Select

The driver uses the Shopify API to process search criteria that refer to the OrderId column. The supported SQL operators are '=' for OrderId. The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

For example, the following queries are processed server side. You can set the Type pseudo column to "DraftOrder" to list order items belonging to draft orders instead of orders, or you can set Type to "AbandonedCheckout" to list order items belonging to abandoned checkouts.

SELECT * FROM OrderItemProperties WHERE OrderId = '123'

Columns