ProductOptions
Returns data from ProductOptions table.
Select
The 本製品 will use the BCart API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- Most of the columns support the following operators: <, >, <=, >=, =, !=, IN, NOT_IN.
- Custom field columns support the following operator: =.
- InputRulesType, InputRulesLimitType, InputRulesLimitMin and InputRulesLimitMax columns does not support server side operators.
SELECT * FROM ProductOptions WHERE Name = 'Sample ProductOptions' SELECT * FROM ProductOptions WHERE Id IN (1,10) SELECT * FROM ProductOptions WHERE UpdatedAt <= '2019-09-26 09:20:45'
Columns
Name | Type | Description |
Id [KEY] | Integer | |
Name | String | |
IsActive | Integer | |
InputType | String | |
InputChoices | String | |
InputRulesType | String | |
InputRulesLimitType | String | |
InputRulesLimitMin | String | |
InputRulesLimitMax | String | |
Unit | String | |
IsDescriptionHtml | Integer | |
Description | String | |
Required | Boolean | |
SortPriority | Integer | |
CreatedAt | Datetime | |
UpdatedAt | Datetime |