ProductVariantEvents
Retrieves event history for product variants.
View-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.
- HostId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM ProductVariantEvents WHERE HostId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique Id. | |
| HostId | String | A globally unique Id. | |
| AppTitle | String | The name of the app that created the event. | |
| AttributeToApp | Bool | Indicates whether the event was created by an app. | |
| AttributeToUser | Bool | Indicates whether the event was caused by an admin user. | |
| CreatedAt | Datetime | The date and time when the event was created. | |
| CriticalAlert | Bool | Indicates whether the event is critical. | |
| Action | String | The action that occurred. | |
| Message | String | Human-readable text that describes the event. | |
| BasicEventSubjectId | String | The Id of the resource that generated the event. | |
| BasicEventSubjectType | String | The type of the resource that generated the event. | |
| BasicEventHasAdditionalContent | Bool | Indicates whether the event has additional content. | |
| BasicEventAdditionalContent | String | Additional content for collapsible timeline events. | |
| BasicEventAdditionalData | String | Additional data for event consumers. | |
| BasicEventSecondaryMessage | String | Human-readable text that supports the main event message. | |
| BasicEventArguments | String | References the event and its associated resources. | |
| CommentEventAuthorId | String | The Id of the staff member who authored the comment event. | |
| CommentEventCanDelete | Bool | Indicates whether the comment event can be deleted. | |
| CommentEventCanEdit | Bool | Indicates whether the comment event can be edited. | |
| CommentEventEdited | Bool | Indicates whether the comment event has been edited. | |
| CommentEventRawMessage | String | The raw body text of the comment event. | |
| CommentEventSubjectId | String | The Id of the parent subject to which the comment event belongs. | |
| CommentEventSubjectHasTimelineComment | Bool | Indicates whether the timeline subject has a timeline comment. | |
| CommentEventEmbedCustomerId | String | The object reference to the associated customer for the comment event. | |
| CommentEventEmbedDraftOrderId | String | The object reference to the associated draft order for the comment event. | |
| CommentEventEmbedOrderId | String | The object reference to the associated order for the comment event. | |
| CommentEventEmbedProductId | String | The object reference to the associated product for the comment event. | |
| CommentEventEmbedProductVariantId | String | The object reference to the associated product variant for the comment event. |