Returns a list of category trees.

Table Specific Information

Select

The driver uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

• Id supports the = and IN comparisons.
• Channels supports the = and IN comparisons.

The rest of the filter is executed client-side within the driver.

For example, the following queries are processed server-side:

SELECT * FROM CategoryTrees WHERE Id = 1;
SELECT * FROM CategoryTrees WHERE Id IN (1,2); 
SELECT * FROM CategoryTrees WHERE Channels = '[1]';
SELECT * FROM CategoryTrees WHERE Channels IN ('[1]', '[100]');

Insert

To insert a category tree, specify the Channel ID in the Channels field. The Channel ID determines the channel where the category tree is created. You can only assign a category tree to one channel. See the example query below.

INSERT INTO CategoryTrees (Name,channels) VALUES ('name','[5]');

Update

The channels field must be absent when updating a category tree. This field is currently unsupported during a category tree update.

UPDATE CategoryTrees SET name = 'test' WHERE Id = 10;

Delete

DELETE FROM CategoryTrees WHERE Id = 18

Columns