Returns data from Products 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: =.
• SubImages1Image, SubImages1Caption and each SubImages number columns does not support server side operators.

For example, the following query is processed server side:

    SELECT * FROM Products WHERE Name = 'Sample Product'
    SELECT * FROM Products WHERE Id IN (1,10)
    SELECT * FROM Products WHERE UpdatedAt <= '2019-09-26 09:20:45'

Insert

To add a Products, specify Name, CategoryId and the non-read-only columns.

    INSERT INTO Products(Name,CategoryId)VALUES('Sample Product',2)

Bulk Insert

    INSERT INTO Products#TEMP (Name,CategoryId) VALUES('Sample Product 1',2)
    INSERT INTO Products#TEMP (Name,CategoryId) VALUES('Sample Product 2',2)
    INSERT INTO Products (Name,CategoryId) SELECT Name,CategoryId FROM Products#TEMP

Update

BCart allows updates for Name, CategoryId and the non-read-only columns.

    UPDATE Products SET Name = 'Sample Product' WHERE Id = 2

Bulk Update

    INSERT INTO Products#TEMP (Id,Name,CategoryId) VALUES(1,'Sample Product 1',2)
    INSERT INTO Products#TEMP (Id,Name,CategoryId) VALUES(2,'Sample Product 2',2)
    UPDATE Products (Id,Name,CategoryId) SELECT Id,Name,CategoryId FROM Products#TEMP

Delete

Delete is not supported for this table.

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Integer	True
MainNo	String	False
Name	String	False
CatchCopy	String	False
CategoryId	Integer	False
SubCategoryId	String	False
FeatureId1	Integer	False
FeatureId2	Integer	False
FeatureId3	Integer	False
MadeIn	String	False
Size	String	False
Sozai	String	False
Caution	String	False
Tag	String	False
Description	String	False
MetaTitle	String	False
MetaKeywords	String	False
MetaDescription	String	False
Image	String	False
ViewGroupFilter	String	False
VisibleCustomerId	String	False
PrependText	String	False
AppendText	String	False
MiddleText	String	False
RvPrependText	String	False
RvAppendText	String	False
RvMiddleText	String	False
FileDownload	String	False
HanbaiStart	Datetime	False
HanbaiEnd	Datetime	False
RecommendProductId	String	False
ViewPattern	Integer	False
Priority	Integer	False
Flag	String	False
UpdatedAt	Datetime	False
SubImages1Image	String	False
SubImages1Caption	String	False
SubImages2Image	String	False
SubImages2Caption	String	False
SubImages3Image	String	False
SubImages3Caption	String	False
SubImages4Image	String	False
SubImages4Caption	String	False
SubImages5Image	String	False
SubImages5Caption	String	False
SubImages6Image	String	False
SubImages6Caption	String	False