OrderRefundLineItems
Retrieve the line items for a refund.
Table Specific Information
Select
WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query.
These columns support only the = comparison, unless stated otherwise. The available columns for this
table are: OrderId, RefundId. All other columns are processed client side. If the 'OrderId' filter is
not specified, the 本製品 will fetch a list of all the orders and perform a request for each order in the list.
The above behaviour will happen apply also for refunds, if 'RefundId' is not specified.
SELECT * FROM OrderRefundLineItems SELECT * FROM OrderRefundLineItems WHERE OrderId = 16 SELECT * FROM OrderRefundLineItems WHERE RefundId = 6 SELECT * FROM OrderRefundLineItems where OrderId IN (12,13) and RefundId IN(5,6)
Columns
Name | Type | References | Description |
Id | Long | Item ID. | |
Name | String | Product name. | |
ProductId | Long | Product ID. | |
VariationId | Long | Variation ID, if applicable. | |
Quantity | Integer | Quantity ordered. | |
TaxClass | Integer | Tax class of product. | |
Subtotal | String | Line subtotal (before discounts). | |
SubtotalTax | String | Line subtotal tax (before discounts). | |
Total | String | Line total (after discounts). | |
TotalTax | String | Line total tax (after discounts). | |
TaxesAggregate | String | Line taxes. See Order refund line item - Taxes properties read-only | |
MetaDataAggregate | String | Meta data. See Order refund - Meta data properties | |
Sku | String | Product SKU. | |
Price | String | Product price. | |
OrderId | String |
Orders.Id | Id of the order. |
RefundId | String |
OrderRefunds.Id | Id of the refund. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description | |
ReferenceNumber | String | This column will be used in Bulk operations to get specific values from the Temp tables. | |
RefundTotal | String | The amount to refund for this line item, excluding taxes. |