Query note attributes belonging to an order or draft order.

View-Specific Information

Select

The adapter uses the Shopify API to process search criteria that refer to the OrderId and OrderUpdatedAt columns. The adapter processes other filters client-side within the adapter. For example, the following queries are processed server-side.

SELECT * FROM OrderDiscountCodes WHERE OrderId = '1'

SELECT * FROM OrderDiscountCodes WHERE OrderId IN ('1', '2')

SELECT * FROM OrderDiscountCodes WHERE OrderUpdatedAt <= '2019-05-13 09:23:06.0'

SELECT * FROM OrderDiscountCodes WHERE OrderUpdatedAt >= '2019-05-13 09:23:06.0'

Columns

Name	Type	References	Description
OrderId [KEY]	Long	Orders.Id	The id of the order.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.
Code [KEY]	String		The name of the note attribute.
Amount	String		The value of the note attribute.
Type	String		The value of the note attribute.