JDBC Driver for WooCommerce

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062