JDBC Driver for WooCommerce

Build 24.0.9062

OrderFeeLines

Retrieve the fee lines for an order.

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 column for this table is: OrderId. 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.

SELECT * FROM OrderFeeLines WHERE OrderId = 21

Columns

Name Type References Description
Id [KEY] Long Item ID.
Name String Fee name.
TaxClass String Tax class of fee.
TaxStatus String Tax status of fee. Options: taxable and none.
Total String Line total (after discounts).
TotalTax String Line total tax (after discounts).
Taxes String Line taxes. See Order - Taxes properties read-only
MetaData String Meta data. See Order - Meta data properties
OrderId String

Orders.Id

Id of the order.

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.

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