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

Tableau Connector for WooCommerce

OrderRefundLineItems

Table Specific Information

Select

Columns

Pseudo-Columns