DiscountApplications
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. |