ArticleComments
Lists comments on blog articles with author details, content, and moderation status.
Table-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.
- Id supports the '=, IN' comparison operators.
- ArticleId supports the '=, IN' comparison operators.
- PublishedAt supports the '=, !=, <, >, >=, <=' comparison operators.
- UpdatedAt supports the '=, !=, <, >, >=, <=' comparison operators.
- CreatedAt supports the '=, !=, <, >, >=, <=' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM ArticleComments WHERE Id = 'Val1'
SELECT * FROM ArticleComments WHERE ArticleId = 'Val1'
SELECT * FROM ArticleComments WHERE PublishedAt = '2023-01-01 11:10:00'
SELECT * FROM ArticleComments WHERE UpdatedAt = '2023-01-01 11:10:00'
SELECT * FROM ArticleComments WHERE CreatedAt = '2023-01-01 11:10:00'
Delete
You can delete entries by specifying the following column:
Id
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The globally unique identifier of the comment. | |
| ArticleId | String | True |
The globally unique identifier of the article associated with the comment. | |
| ArticleTitle | String | True |
The title of the article that the comment is attached to. | |
| Body | String | True |
The plain text content of the comment. | |
| BodyHtml | String | True |
The comment content with HTML formatting included. | |
| Status | String | True |
The current status of the comment, such as approved, pending, or spam. | |
| Ip | String | True |
The IP address from which the commenter submitted the comment. | |
| UserAgent | String | True |
The user agent string of the commenter's browser or application. | |
| AuthorName | String | True |
The display name of the commenter. | |
| AuthorEmail | String | True |
The email address of the commenter. | |
| IsPublished | Bool | True |
Indicates whether the comment has been published. | |
| PublishedAt | Datetime | True |
The date and time when the comment was published. | |
| UpdatedAt | Datetime | True |
The date and time when the comment was most recently updated. | |
| CreatedAt | Datetime | True |
The date and time when the comment was originally created. |