ADO.NET Provider for Lohaco

Build 21.0.7930

GroupAttributes

Retrieve information related to group attributes.

Select

The {i will use the Lohaco API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the {i.

  • GroupCd support the following operators: =.
For example, the following query is processed server side:
SELECT * FROM GroupAttributes

SELECT * FROM GroupAttributes WHERE GroupCd='group code'
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Insert

To add a new GroupAttributes

Insert into GroupAttributes (GroupCd,AttributeCd,AttributeValueCd) values ('group code','237P',40100)

Delete

GroupAttributes can be deleted by providing the AttributeCd and GroupCd .

DELETE FROM GroupAttributes WHERE GroupCd='t-hunglead-newom-sample0groupardit' AND AttributeCd='attributecd'

Columns

Name Type ReadOnly References Description
SellerId String False

The Id of the seller.

GroupCd [KEY] String False

Groups.GroupCd

Product group code.

AttributeCd [KEY] String False

Attribute item code.

AttributeName String True

Attribute item name.

AttributeValueCd String False

Attribute value code.

AttributeValueName String True

Attribute value name.

AttributeValueText String False

Attribute value text.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930