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 driver uses the AdobeCommerce API to filter the results by Sku while the rest of the filter is executed client side within the driver.
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 |