DownloadableSample
DownloadableSample is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table.
Table Specific Information
Select
The add-in uses the AdobeCommerce API to filter the results by Sku while the rest of the filter is executed client side within the add-in.
You must specify the Sku column in the WHERE clause to retrieve results from DownloadableSample. Sku can be used only with the equals (=) operator.
For example:
SELECT * FROM [DownloadableSample] WHERE Sku = '123'
Insert
To create a new downloadable sample, the Sku, SampleType, SortOrder and Title columns are required.
INSERT INTO DownloadableSample (Sku, SampleType, SortOrder, Title) VALUES ('WJ02', 'crosssell', 12, 'simple')
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | Int | False |
Sample(or link) id |
Sku | String | False |
sku |
ExtensionAttributes | String | False |
This is an auto-generated column |
SampleFile | String | False |
relative file path |
SampleFileContent | String | False |
This is an auto-generated column |
SampleType | String | False |
This is an auto-generated column |
SampleUrl | String | False |
file URL |
SortOrder | Int | False |
Order index for sample |
Title | String | False |
Title |