Comments
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | Long | True | A unique numeric identifier for the comment. |
BlogId | Long | False | A unique numeric identifier for the blog containing the article that the comment belongs to. |
ArticleId | Long | False | A unique numeric identifier for the article that the comment belongs to. |
Author | String | False | The name of the author of the comment. |
Body | String | False | The basic Textile markup of a comment. |
BodyHtml | String | False | The text of the comment, complete with HTML markup. |
CreatedAt | Datetime | True | The date and time (ISO 8601 format) when the comment was created. |
String | False | The email address of the author of the comment. | |
Ip | String | False | The IP address from which the comment was posted. |
PublishedAt | String | False | The date and time (ISO 8601 format) when the comment was published. |
Status | String | True | The status of the comment. The allowed values are pending, approved, unapproved, spam, published, removed. |
UpdatedAt | Datetime | True | The date and time (ISO 8601 format) when the comment was last modified. |
UserAgent | String | False | The user agent string provided by the software used to create the comment. |
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 |
published_status | String | Filter comments by their publish status. Valid values are: published, unpublished and any ; default: any. |
status | String | Filter comments by their status. Valid values are: published, pending and unapproved |
Last updated