Returns
Retrieves a list of returns for the order.
Select
The 本製品 uses the Shopify API to process WHERE clause conditions built with the following column and operator. The 本製品 processes other filters client-side within the 本製品.
- OrdersId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM Returns
SELECT * FROM Returns WHERE OrdersId = 'Val1'
Insert
Insert statements are mapped to the 'returnCreate' GraphQL mutation.
The following columns can be used to create a new record:
OrdersId, ReturnLineItems
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A globally-unique ID. | |
| OrdersId | String | True |
Orders.Id |
A globally-unique ID. |
| Name | String | True |
The name of the return. | |
| Status | String | True |
The status of the return. | |
| TotalQuantity | Int | True |
The sum of all line item quantities for the return. | |
| DeclineReason | String | True |
The reason the customer's return request was declined. | |
| DeclineNote | String | True |
The notification message sent to the customer about their declined return request. Maximum length: 500 characters. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御したり、INSERT ステートメントのパラメータとして使用したりすることができます。
| Name | Type | Description |
| ReturnLineItems | String |
The list of the line items in the return. |