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.
Email	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