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 supported SQL operators are '=' for OrderId and '>' and '<' for OrderUpdatedAt. The connector processes other filters client-side within the connector. For example, the following queries are processed server-side.

SELECT * FROM NoteAttributes WHERE OrderId = '123'

SELECT * FROM NoteAttributes WHERE OrderUpdatedAt > '2018-05-05'

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.
Name	String		The name of the note attribute.
Value	String		The value of the note attribute.