Comments
Create, read, update and delete the comments.
Table-Specific Information
Select
The adapter processes all filters client-side within the adapter. The following queries are the only ones processed server side:
SELECT * FROM Comments
SELECT * FROM Comments WHERE Id='123'
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 |