UserLikedPosts
List the UserLikedPosts for the WordPressOnline website.
Table Specific Information
SELECT
The connector uses the WordPress API to process some of the filters.
- DateRangeAfter supports the '<', '>' comparisons.
- DateRangeBefore supports the '<', '>' comparisons.
The connector processes other filters client-side within the connector.
For example, the following queries are processed server side.
SELECT * FROM UserLikedPosts
SELECT * FROM UserLikedPosts where where DateRangeBefore<'2025-05-08'
Columns
| Name | Type | References | Description |
| DateRangeAfter | Datetime | DEPRECATED. Filters liked posts to include only those created after this date and time. | |
| DateRangeBefore | Datetime | DEPRECATED. Filters liked posts to include only those created before this date and time. | |
| Number | Int | DEPRECATED. The total number of liked posts returned in the query. | |
| Posts | String | DEPRECATED. An array containing details about each post the user has liked, including title, ID, and publication information. | |
| Id [KEY] | Long |
Posts.Id | The unique identifier of the liked post. |
| SiteId | Int | The unique identifier of the site the post belongs to. | |
| AuthorId | Int | The unique identifier of the post's author. | |
| AuthorLogin | String | The username of the post's author. | |
| AuthorName | String | The display name of the post's author. | |
| AuthorFirstName | String | The first name of the post's author. | |
| AuthorLastName | String | The last name of the post's author. | |
| AuthorNiceName | String | The URL-friendly version of the author's username. | |
| AuthorUrl | String | The personal website URL of the post's author. | |
| AuthorAvatarUrl | String | The URL of the author's avatar image. | |
| AuthorProfileUrl | String | The URL of the author's public WordPress profile page. | |
| AuthorSiteId | Int | The unique identifier of the site associated with the author. | |
| AuthorIsSiteVisible | Boolean | Indicates whether the author's site is publicly visible. | |
| Date | Datetime | The date and time the post was published. | |
| Modified | Datetime | The date and time the post was last updated. | |
| Title | String | The title of the post. | |
| Url | String | The full permalink URL of the post. | |
| ShortUrl | String | The WordPress shortlink (wp.me) version of the post URL. | |
| Content | String | The full HTML content of the post. | |
| Excerpt | String | A short excerpt or summary of the post content. | |
| Slug | String | The URL-friendly slug used to identify the post. | |
| Guid | String | The globally unique identifier (GUID) for the post. | |
| Status | String | The publication status of the post, such as publish, draft, pending, private, future, or trash. | |
| IsSticky | Boolean | Indicates whether the post is marked as sticky and displayed at the top of the blog. | |
| Password | String | The plaintext password used to protect the post, or an empty string if the post is not password-protected. | |
| HasParent | Boolean | Indicates whether the post has a parent post (for example, a child page). | |
| Type | String | The post type, such as post, page, revision, or another registered custom post type. | |
| HasCommentsOpen | Boolean | Indicates whether comments are currently open for the post. | |
| IsPingsOpen | Boolean | Indicates whether pingbacks and trackbacks are enabled for the post. | |
| HasLikesEnabled | Boolean | Indicates whether the post allows likes. | |
| HasSharingEnabled | Boolean | Indicates whether sharing buttons are enabled for the post. | |
| CommentCount | Int | The total number of comments associated with the post. | |
| LikeCount | Int | The total number of likes the post has received. | |
| ILike | Boolean | Indicates whether the current authenticated user has liked the post. | |
| IsReblogged | Boolean | Indicates whether the current authenticated user has reblogged the post. | |
| IsFollowing | String | Indicates whether the current authenticated user is following the post. | |
| GlobalId | String | A WordPress.com-wide unique identifier for the post. | |
| PseudoId | String | A unique pseudo identifier for the post, used when the post originates from an external feed. | |
| FeaturedImage | String | The URL of the post's featured image, if one is set. | |
| Thumbnail | String | The attachment object representing the post's featured image, if available. | |
| Format | String | The display format of the post, such as standard, aside, chat, gallery, link, image, quote, status, video, or audio. | |
| HasGeo | Boolean | Indicates whether the post includes geographic location data. | |
| MenuOrder | Int | The order in which pages or hierarchical posts appear in navigation menus. | |
| PublicizeUrls | String | A list of URLs where the post was automatically shared via Publicize connections (for example, Facebook). | |
| Tags | String | A collection of tags (keyed by tag name) applied to the post. | |
| Categories | String | A collection of categories (keyed by category name) applied to the post. | |
| Attachments | String | A collection of media attachments associated with the post (keyed by attachment ID). | |
| Metadata | String | A list of custom metadata key-value pairs associated with the post. | |
| HasCapabilitiesPublishPost | Boolean | Indicates whether the authenticated user has permission to publish the post. | |
| HasCapabilitiesDeletePost | Boolean | Indicates whether the authenticated user has permission to delete the post. | |
| HasCapabilitiesEditPost | Boolean | Indicates whether the authenticated user has permission to edit the post. | |
| HasCurrentUserCanPublishPost | Boolean | Indicates whether the current user can publish the post. | |
| HasCurrentUserCanDeletePost | Boolean | Indicates whether the current user can delete the post. | |
| HasCurrentUserCanEditPost | Boolean | Indicates whether the current user can edit the post. | |
| IsExternal | Boolean | Indicates whether the post originates from an external, non-WordPress.com feed. | |
| SiteName | String | The name of the site where the post was published. | |
| SiteUrl | String | The URL of the site where the post was published. | |
| SiteIsPrivate | Boolean | Indicates whether the site is private or restricted from public access. | |
| FeaturedMedia | String | The media object featured or attached to the post, including its URL and dimensions. | |
| FeedId | Int | The identifier of the RSS/Atom feed the post was retrieved from, if it originates from an external feed. | |
| DateLiked | Datetime | The date and time the current user liked the post. |