Collects

Query, insert, or delete information regarding different collects.

Table-Specific Information

The adapter processes all filters client-side within the adapter. The following queries are the only ones processed server side:

SELECT * FROM Collects

SELECT * FROM Collects WHERE Id='123'

You must specify the ProductId and CollectionId to create a collect.

INSERT INTO Collects (ProductId, CollectionId) VALUES ('512433520663','22892937239')

You must specify the Id of the collect to delete it.

DELETE FROM Collects WHERE id ='123'

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the collect.
CollectionId	Long	False	CustomCollections.Id	The Id of the collection this collection is linked with.
ProductId	Long	False	Products.Id	The Id of the product this collection is linked with.
Position	Int	True		The position of this product in a manually sorted custom collection. The first position is 1. This value is applied only when the custom collection is sorted manually.
SortValue	String	True		This is the same value as position but padded with leading zeroes to make it alphanumeric-sortable.
CreatedAt	Datetime	True		The date and time when the collect was created.
UpdatedAt	Datetime	True		The date and time when the collect was last modified.