JDBC Driver for WooCommerce

Build 23.0.8839

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 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 Id of the product.

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