JDBC Driver for WooCommerce

Build 24.0.9062

ProductAttributes

Retrieve product attributes.

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: ProductId. All other columns are processed client side. If the 'ProductId' filter is not specified, the 本製品 will fetch a list of all the products and perform a request for each product in the list.

SELECT * FROM ProductAttributes WHERE ProductId = 4

Columns

Name Type References Description
Id [KEY] Long Attribute ID.
Name String Attribute name.
Slug String An alphanumeric identifier for the resource unique to its type.
Type String Type of attribute. By default only select is supported.
OrderBy String Default sort order. Options: menu_order, name, name_num and id. Defaults to menu_order.
HasArchives Boolean Enable/Disable attribute archives. Defaults to false.
ProductId Long

Products.Id

Id of the product.

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