JDBC Driver for GMO MakeShop

Build 24.0.9062

ProductNameOptionGroups

Returns information related to product naming option groups and items.

Select

The 本製品 will use the GMO MakeShop API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • BrandCode column supports the = operator.
For example, the following queries are processed server side:
SELECT * FROM ProductNameOptionGroups WHERE BrandCode = 'CD12345'

Columns

Name Type Description
BrandCode [KEY] String System product code.
NameOptionGroupId Integer Insert name group ID.
NameOptionGroupLabel String Insert name group name.
NameOptionGroupDescription String Insert name group description.
ItemId [KEY] Integer Item ID.
AdminItemName String Administrator item name.
DisplayItemName String Display item name.
IsRequired String Selection requirement - Y: Required input N: Optional input.
IsAlphabet String Alphabetical validation - Y: Can be input N: Can not be input.
IsNumber String Numerical validation - Y: Can be input N: Can not be input.
IsSymbol String Symbols validation - Y: Can be input N: Can not be input.
IsDoubleByte String Double byte character validation - Y: Can be input N: Can not be input.
RowMaxlength Integer Number of characters per line.
MaxRow Integer Number of lines.
MaxLength Integer Maximum number of characters.

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