CommentLikes
Returns information about likes on WordPress comments, including the number of likes each comment has received.
Table Specific Information
SELECT
The connector uses the WordPress API to process some of the filters.
- CommentId supports the '=' comparison.
The connector processes other filters client-side within the connector.
For example, the following queries are processed server side.
SELECT * FROM CommentLikes WHERE CommentId = 10
Columns
| Name | Type | References | Description |
| CommentId [KEY] | Int |
Comments.Id | The unique identifier of the comment that received the like. |
| ID [KEY] | Int | The unique identifier of the user who liked the comment. | |
| Name | String | The display name of the user who liked the comment. | |
| Login | String | The WordPress username of the user who liked the comment. | |
| String | The email address of the user who liked the comment. | ||
| IPAddress | String | The IP address from which the comment was liked. | |
| FirstName | String | The first name of the user who liked the comment. | |
| LastName | String | The last name of the user who liked the comment. | |
| NiceName | String | The URL-friendly version of the user's display name used in WordPress profile links. | |
| SiteID | Int | The unique identifier of the site associated with the user who liked the comment. | |
| IsSiteVisible | Bool | Indicates whether the site associated with the user is publicly visible in WordPress. | |
| ProfileURL | String | The URL linking to the WordPress profile of the user who liked the comment. | |
| DefaultAvatar | Bool | Indicates whether the user is using the default WordPress avatar image. | |
| AvatarURL | String | The URL of the avatar image for the user who liked the comment. | |
| ItemURL | String | The URL linking directly to the comment that was liked. | |
| MetaAggregate | String | Aggregated metadata for the comment like record returned by the WordPress API. |