Brands

Gets the collection of brands.

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 =, >, <, >=, <=, IN, and NOT IN comparisons.
Name supports the = comparison.
PageTitle supports the = comparison.

The rest of the filter is executed client-side within the driver. For example, the following queries are processed server-side:

SELECT * FROM Brands WHERE Id = 1;

SELECT * FROM Brands WHERE Id >= 1 AND Id <= 5;

SELECT * FROM Brands WHERE Id in (51,54);

SELECT * FROM Brands WHERE Id not in (51,54);

SELECT * FROM Brands WHERE PageTitle = 'modern';

SELECT * FROM Brands WHERE Name = 'Test';

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The id of the brand.
Name	String	False		The name of the brand. Must be unique.
PageTitle	String	False		The title shown in the browser while viewing the brand.
MetaKeywords	String	False		An array of meta keywords to include in the HTML.
MetaDescription	String	False		A meta description to include.
ImageURL	String	False		Image URL used for this category on the storefront.
SearchKeywords	String	False		A comma-separated list of keywords that can be used to locate this brand.
ItemURL	String	False		The custom URL for the product on the storefront.
ItemURLIsCustomized	Boolean	False		Returns true if the URL has been changed from its default state (the auto-assigned URL that BigCommerce provides).

JDBC Driver for BigCommerce

Brands

Table Specific Information

Select

Columns