Excel Add-In for BCart

Build 22.0.8503

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.
For example, the following query is processed server side:
    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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8503