Comments
Create, read, update and delete the comments.
Table-Specific Information
Select
The driver processes all filters client-side within the driver. The following queries are the only ones processed server side:
SELECT * FROM Comments
SELECT * FROM Comments WHERE Id='123'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Insert
You must specify Article Id, Author, Body, Email to create a Comment.
INSERT INTO Comments(articleid,author,body,email) VALUES ('5557001','Harry','test','test@test.com')
Update
You must specify the Id to update a Comment. For example:
UPDATE Comments SET Author='Adam' WHERE Id = '77171130'
Delete
You must specify the Id of the Comments to delete it.
DELETE FROM Comments WHERE Id = '555695'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
A unique numeric identifier for the comment. | |
BlogId | Long | False |
Blogs.Id |
A unique numeric identifier for the blog containing the article that the comment belongs to. |
ArticleId | Long | False |
Articles.Id |
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 |