Query note attributes belonging to an order or draft order.

View-Specific Information

Select

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

SELECT * FROM DiscountApplications WHERE OrderId = '1'

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

SELECT * FROM DiscountApplications WHERE OrderUpdatedAt <= '2020-07-20 08:28:03.0'

SELECT * FROM DiscountApplications WHERE OrderUpdatedAt > '2020-07-20 08:28:03.0'

Columns

Name	Type	References	Description
OrderId	Long	Orders.Id	The id of the order.
OrderUpdatedAt	Datetime		The date and time when the order was last modified.
Type	String		The name of the note attribute.
Title	String		The value of the note attribute.
Description	String		The value of the note attribute.
Value	String		The value of the note attribute.
ValueType	String		The value of the note attribute.
AllocationMethod	String		The value of the note attribute.
TargetSelection	String		The value of the note attribute.
TargetType	String		The value of the note attribute.