OrderItemProperties
Query order item properties.
View-Specific Information
Select
The adapter uses the Shopify API to process search criteria that refer to the OrderId column. The supported SQL operators are '=' for OrderId. The adapter processes other filters client-side within the adapter.
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
| Name | Type | References | Description |
| ItemId | Long |
OrdersItems.ItemId | The id of the order item. Only available for orders. |
| OrderId | Long |
Orders.Id | The id of the order. |
| Name | String | The name of the item property. | |
| Value | String | The value of the item property. |