DraftOrderItemProperties
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. |