Collects
Query, insert, or delete information regarding different collects.
Table-Specific Information
Select
The driver processes all filters client-side within the driver. The following queries are the only ones processed server side:
SELECT * FROM Collects
SELECT * FROM Collects WHERE Id='123'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Insert
You must specify the ProductId and CollectionId to create a collect.
INSERT INTO Collects (ProductId, CollectionId) VALUES ('512433520663','22892937239')
Delete
You must specify the Id of the collect to delete it.
DELETE FROM Collects WHERE id ='123'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
A unique numeric identifier for the collect. | |
CollectionId | Long | False |
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. |