ProductImages
Retrieve images for a product.
Table Specific Information
Select
WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query. Following columns are supported server side, all other columns are processed client side. If the 'ProductId' filter is not specified, the driver will fetch a list of all the attributes and perform a request for each attribute in the list.
- Id supports the '=' operator.
- Name supports the '=' operator.
- Src supports the '=' operator.
- Alt supports the '=' operator.
- ProductId supports the '=,IN,NOT IN' operator.
- DateCreated supports the '>,<,>=,<=,=' operators.
- DateModified supports the '>,<,>=,<=,=' operators.
SELECT * FROM ProductImages WHERE Id = 4 SELECT * FROM ProductImages WHERE ProductId = 6 SELECT * FROM ProductImages WHERE DateCreated = '2024-08-22 08:47:21.0' SELECT * FROM ProductImages WHERE DateModified = '2024-08-22 08:47:21.0'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Image ID. | |
| DateCreated | Datetime | The date the image was created, in the site's timezone. | |
| DateModified | Datetime | The date the image was last modified, in the site's timezone. | |
| Src | String | Image URL. | |
| Name | String | Image name. | |
| Alt | String | Image alternative text. | |
| ProductId [KEY] | Long |
Products.Id | Id of the product. |
Pseudo-Columns
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.
| Name | Type | Description | |
| ReferenceNumber | String | This column will be used in Bulk operations to get specific values from the Temp tables. |