OrderDiscountCodes
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 | Long |
Orders.Id | The id of the order. |
| OrderUpdatedAt | Datetime | The date and time when the order was last modified. | |
| Code | String | The name of the note attribute. | |
| Amount | String | The value of the note attribute. | |
| Type | String | The value of the note attribute. |