DraftOrderItemProperties
Query order item properties.
View-Specific Information
Select
The driver uses the Shopify API to process search criteria that refer to the DraftOrderId column. The supported SQL operators are '=' for DraftOrderId. 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.
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. |