RecentComments
Get a list of recent comments on a post.
Table Specific Information
SELECT
The add-in uses the WordPress API to process some of the filters.
- PostId supports the '=' comparison.
- Type supports the '=' comparison.
- Status supports the '=' comparison.
- Date supports the '<=', '>=' comparisons.
The add-in processes other filters client-side within the add-in.
For example, the following queries are processed server side.
SELECT * FROM RecentComments where PostID=21
SELECT * FROM RecentComments where Status='approved'
Columns
| Name | Type | References | Description |
| ID [KEY] | Int |
Comments.Id | The unique identifier of the comment. |
| Type | String | The type of comment, such as standard comment, trackback, or pingback. | |
| Status | String | The current moderation status of the comment, such as approved, pending, or spam. | |
| Date | Datetime | The date and time when the comment was posted, in the site's timezone. | |
| Content | String | The rendered HTML content of the comment as displayed on the site. | |
| RawContent | String | The raw comment text including any block-level or markup data before rendering. | |
| PostID | Int | The unique identifier of the post or page that the comment belongs to. | |
| PostLink | String | The API endpoint or URL used to retrieve details about the related post. | |
| PostTitle | String | The title of the post that the comment was made on. | |
| PostType | String | The content type of the associated post, such as post or page. | |
| ParentCommentAggregate | String | A JSON object contains details of the parent comment if the comment is a reply. It returns false if the comment is a top-level comment. | |
| LikeCount | Int | The total number of likes the comment has received. | |
| IReplied | Bool | Indicates whether the authenticated user has replied to this comment. | |
| ILike | Bool | Indicates whether the authenticated user has liked this comment. | |
| CanModerate | Bool | Indicates whether the authenticated user has permission to moderate this comment. | |
| AuthorAvatarURL | String | The URL to the comment author's avatar image. | |
| AuthorEmail | String | The email address of the comment author. | |
| AuthorFirstName | String | The first name of the comment author. | |
| AuthorID | Int | The unique identifier of the comment author. | |
| AuthorIPAddress | String | The IP address from which the comment was submitted. | |
| AuthorLastName | String | The last name of the comment author. | |
| AuthorLogin | String | The username of the comment author. | |
| AuthorName | String | The public display name of the comment author. | |
| AuthorNiceName | String | A URL-friendly version of the author's username. | |
| AuthorProfileURL | String | The Gravatar or profile URL associated with the author. | |
| AuthorAiteID | Int | The ID of the WordPress site where the author posted the comment. | |
| HasAuthorSiteVisible | Bool | Indicates whether the author's site is publicly visible. | |
| AuthorURL | String | The URL of the author's personal or linked website. | |
| ShortURL | String | The WordPress shortlink (wp.me) that provides a shortened URL to the comment. | |
| ItemURL | String | The full permalink URL to the comment on the WordPress site. |