ProductMedia
Last updated
Last updated
ProductMedia is an auto generated table
You must specify the Sku_p column in the WHERE clause to retrieve results from ProductMedia. Sku_p can be used only with the equals (=) operator.
The driver will use the Magento API to filter the results by Sku_p while the rest of the filter is executed client side within the driver. For example, the following query is processed server side:\
You can turn off client-side execution by setting SupportEnhancedSQL to false, in which case any search criteria that refers to any other columns will cause an error.
To update a ProductMedia record, you must set Sku and EntryId (refers to the Id column).\
Product media can be deleted by providing Sku_p and EntryId_p (refers to the Id column).\
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
SELECT * FROM [ProductMedia] WHERE Sku = 'sjl-8082'
UPDATE ProductMedia SET Label = 'lbl new'
WHERE EntryId = '1'
AND Sku = 'sjl-8082'
DELETE FROM ProductMedia WHERE EntryId = 1 AND Sky = 'sjl-8082'
Name
Type
ReadOnly
Description
Id [KEY]
Int
False
Gallery entry ID
Content
String
False
This is an auto-generated column
Disabled
Bool
False
If gallery entry is hidden from product page
ExtensionAttributes
String
False
This is an auto-generated column
File
String
False
File path
Label
String
False
Gallery entry alternative text
MediaType
String
False
Media type
Position
Int
False
Gallery entry position (sort order)
Types
String
False
Gallery entry image types (thumbnail, image, small_image etc)
Name
Type
Description
Sku_p
String
This is an auto-generated column
EntryId_p
Int
This is an auto-generated column