ADO.NET Provider for WooCommerce

Build 20.0.7587

ProductAttributeTerms

Retrieve the terms for an attribute.

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: Id, Slug, AttributeId, ProductId. All other columns are processed client side. If the 'AttributeId' filter is not specified, the provider will fetch a list of all the attributes and perform a request for each attribute in the list.

SELECT * FROM ProductAttributeTerms

SELECT * FROM ProductAttributeTerms WHERE AttributeId = 4
SELECT * FROM ProductAttributeTerms WHERE ProductId = 41 and Slug = 'criteria'
ProductAttributeTerms.rsd

Insert

The following attributes are required when performing an insert: Name, AttributeId.

INSERT INTO ProductAttributeTerms (Name, AttributeId) VALUES ('term_name', 2)

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Unique identifier for the resource.

Name String False

Term name.

Slug String False

An alphanumeric identifier for the resource unique to its type.

Description String False

HTML description of the resource.

MenuOrder Integer False

Menu order, used to custom sort the resource.

Count Integer True

Number of published products for the resource.

AttributeId Integer True

Id of the attribute.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587