PostsTags

List the UserLikedPosts for the WordPressOnline website.

Table Specific Information

SELECT

The provider uses the WordPress API to process some of the filters.

Date supports the '<', '>' comparisons.
Modified supports the '<', '>' comparisons.
Status supports the '=' comparison.
Type supports the '=' comparison.

The provider processes other filters client-side within the provider.

For example, the following queries are processed server side.

SELECT * FROM PostsTags
SELECT * FROM PostsTags where Status='publish'
SELECT * FROM PostsTags where Type='post'

Columns


Name	Type	References	Description
ID [KEY]	Integer	Posts.Id	The unique identifier of the post.
SiteID	Integer		The unique identifier of the WordPress site that the post belongs to.
AuthorID	Int		The unique identifier of the author who created the post.
DateRangeBefore	String		Filters results to posts created before the specified date.
DateRangeAfter	String		Filters results to posts created after the specified date.
AuthorLogin	String		The username of the post's author.
IsAuthorEmailAvailable	Boolean		Indicates whether the author's email address is available.
AuthorName	String		The display name of the post's author.
AuthorAvatarURL	String		The URL of the author's avatar image.
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.
AuthorProfileURL	String		The URL of the author's public WordPress profile page.
AuthorSiteID	Int		The ID of the site associated with the author.
AuthorURL	String		The personal website URL provided by the author, if available.
IsAuthorIpAddressAvailable	Boolean		Indicates whether the author's IP address is available.
IsAuthorSiteVisible	Boolean		Indicates whether the author's site is publicly visible.
Date	Datetime		The date and time when the post was created in the site's local timezone.
Modified	Datetime		The date and time when the post was last updated.
Title	String		The title of the post.
ItemURL	String		The full permalink URL for 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, often representing its original permalink.
Status	String		A comma-separated list of post statuses to query, such as publish, private, draft, pending, future, or trash. Defaults to publish.
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, 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.
FeaturedImage	String		The URL of the post's featured image, if one is set.
PostThumbnail	String		The attachment object representing the featured image, if available.
Format	String		The display format of the post, such as standard, aside, gallery, image, quote, status, video, or audio.
HasGeo	Boolean		Indicates whether the post includes geolocation data.
MenuOrder	Int		The order in which pages or hierarchical posts appear in navigation menus.
PublicizeURLsAggregates	String		A list of URLs where the post was automatically shared via Publicize connections (for example, Facebook or Twitter).
CategoriesAggregates	String		A collection of categories (keyed by category name) applied to the post.
TagsAggregates	String		A collection of tags (keyed by tag name) applied to the post.
Attachments	String		A collection of attachments associated with the post (keyed by attachment ID). Returns up to 20 of the most recent attachments.
MetadataAggregates	String		A list of metadata key-value pairs associated with the post.
MetaAggregates	String		Additional metadata key-value pairs describing the post's extended properties.
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.
HasCapabilitiesPublishPost	Boolean		Indicates whether the authenticated user has permission to 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.
HasCurrentUserCanPublishPost	Boolean		Indicates whether the current user can publish the post.
PseudoID	String		A unique pseudo identifier for the feed item, used when the post originates from a feed or external source.
IsExternal	Boolean		Indicates whether the post originates from an external source.
SiteName	String		The name of the site where the post was published.
SiteURL	String		The URL of the site where the post was published.
IsSitePrivate	Boolean		Indicates whether the site is private or restricted from public access.
FeaturedMedia	String		The media file featured or attached to the post.
Tags	String		The list of tags applied to the post.

ADO.NET Provider for WordPress

PostsTags

Table Specific Information

SELECT

Columns