Query order item properties.

View-Specific Information

Select

The adapter uses the Shopify API to process search criteria that refer to the DraftOrderId column. The supported SQL operators are '=' for DraftOrderId. The adapter processes other filters client-side within the adapter.

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

SELECT * FROM DraftOrderItemProperties WHERE DraftOrderId = '123'

Columns

Name	Type	References	Description
ItemId	Long	DraftOrderItems.ItemId	The id of the order item.
DraftOrderId	Long	DraftOrders.Id	The id of the draft.
Name	String		The name of the item property.
Value	String		The value of the item property.