JDBC Driver for Shopify

Build 23.0.8839

DraftOrderItemProperties

Query order item properties.

View-Specific Information

Select

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

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839