PostTypes
List the PostTypes for the WordPressOnline website.
Table Specific Information
SELECT
The server processes all the filters client-side within the server.
For example,
SELECT * FROM PostTypes;
Columns
| Name | Type | References | Description |
| Name [KEY] | String | The slug identifier for the post type, used internally and in REST API endpoints. | |
| Label | String | The human-readable name for the post type as displayed in the WordPress admin menu. | |
| IsApiQueryable | Bool | Indicates whether this post type can be queried and accessed through the REST API. | |
| Description | String | A short description of what the post type represents or is used for. | |
| IsHierarchical | Bool | Indicates whether the post type supports parent and child relationships, like pages. | |
| CapabilitiesCreatePosts | String | Defines the capability required to create new posts of this type. | |
| CapabilitiesDeleteOthersPosts | String | Defines the capability required to delete posts created by other users. | |
| CapabilitiesDeletePost | String | Defines the capability required to delete a single post. | |
| CapabilitiesDeletePosts | String | Defines the capability required to delete multiple posts. | |
| CapabilitiesDeletePrivatePosts | String | Defines the capability required to delete private posts. | |
| CapabilitiesDeletePublishedPosts | String | Defines the capability required to delete published posts. | |
| CapabilitiesEditOthersPosts | String | Defines the capability required to edit posts created by other users. | |
| CapabilitiesEditPost | String | Defines the capability required to edit a single post. | |
| CapabilitiesEditPosts | String | Defines the capability required to edit multiple posts. | |
| CapabilitiesEditPrivatePosts | String | Defines the capability required to edit private posts. | |
| CapabilitiesEditPublishedPosts | String | Defines the capability required to edit published posts. | |
| CapabilitiesPublishPosts | String | Defines the capability required to publish posts. | |
| CapabilitiesRead | String | Defines the general capability required to read posts of this type. | |
| CapabilitiesReadPost | String | Defines the capability required to read a single post. | |
| CapabilitiesReadPrivatePosts | String | Defines the capability required to read private posts. | |
| LabelsAddNew | String | The text label for adding a new post of this type. | |
| LabelsAddNewItem | String | The text label for adding a new item of this post type. | |
| LabelsAllItems | String | The label used to display all items of this post type. | |
| LabelsArchives | String | The label used to describe the post type archive page. | |
| LabelsAttributes | String | The label for displaying post attributes, such as template or order. | |
| LabelsEditItem | String | The text label for editing a single item of this post type. | |
| LabelsFeaturedImage | String | The label used to describe the featured image section. | |
| LabelsFilterByDate | String | The label for the date filter dropdown in the admin list view. | |
| LabelsFilterItemsList | String | The label for filtering items in the admin list table. | |
| LabelsInsertIntoItem | String | The label for the button that inserts media into this post type. | |
| LabelsItemLink | String | The label describing a permalink to a single item. | |
| LabelsItemLinkDescription | String | The label describing the permalink text or tooltip. | |
| LabelsItemPublished | String | The label displayed when a post of this type is published. | |
| LabelsItemPublishedPrivately | String | The label displayed when a post of this type is published privately. | |
| LabelsItemRevertedToDraft | String | The label displayed when a post of this type is reverted to draft. | |
| LabelsItemScheduled | String | The label displayed when a post of this type is scheduled for publication. | |
| LabelsItemTrashed | String | The label displayed when a post of this type is moved to the trash. | |
| LabelsItemUpdated | String | The label displayed when a post of this type is updated. | |
| LabelsItemsList | String | The label for listing items of this post type in the admin area. | |
| LabelsItemsListNavigation | String | The label for navigating the list of items in the admin view. | |
| LabelsMenuName | String | The name used for this post type in the admin menu. | |
| LabelsName | String | The plural name of the post type. | |
| LabelsNameAdminBar | String | The name used for this post type in the WordPress admin bar. | |
| LabelsNewItem | String | The label used for creating a new item of this post type. | |
| LabelsNotFound | String | The message displayed when no posts of this type are found. | |
| LabelsNotFoundInTrash | String | The message displayed when no posts of this type are found in the trash. | |
| LabelsParentItemColon | String | The label used to indicate the parent item field. | |
| LabelsRemoveFeaturedImage | String | The label for the option to remove a featured image. | |
| LabelsSearchItems | String | The label for the search box when searching posts of this type. | |
| LabelsSetFeaturedImage | String | The label for the option to set a featured image. | |
| LabelsSingularName | String | The singular name of the post type. | |
| LabelsTemplateName | String | The label for the template name field for this post type. | |
| LabelsUploadedToThisItem | String | The label for media uploaded to this post type. | |
| LabelsUseFeaturedImage | String | The label for using a featured image. | |
| LabelsViewItem | String | The label for viewing a single item of this post type. | |
| LabelsViewItems | String | The label for viewing multiple items of this post type. | |
| HasMapMetaCap | Bool | Indicates whether meta capability mapping is enabled for this post type. | |
| IsPublic | Bool | Indicates whether the post type is publicly visible. | |
| IsPubliclyQueryable | Bool | Indicates whether queries can be performed on the front end for this post type. | |
| HasShowUi | Bool | Indicates whether this post type should have a visible interface in the admin dashboard. | |
| HasSupportsAuthorDropDownEnabled | Bool | Indicates whether the Author selection dropdown is enabled for this post type. | |
| HasSupportsAutosave | Bool | Indicates whether autosave is enabled for this post type. | |
| HasSupportsComments | Bool | Indicates whether comments are supported for this post type. | |
| HasSupportsContent | Bool | Indicates whether the main content editor is supported for this post type. | |
| HasSupportsCustomFields | Bool | Indicates whether custom fields are supported for this post type. | |
| HasSupportsEditor | Bool | Indicates whether the block or classic editor is supported for this post type. | |
| HasSupportsExcerpt | Bool | Indicates whether excerpts are supported for this post type. | |
| HasSupportsGeoLocation | Bool | Indicates whether geolocation fields are supported for this post type. | |
| HasSupportsJetpackPostLikes | Bool | Indicates whether Jetpack post likes are supported for this post type. | |
| HasSupportsNewspackBlocks | Bool | Indicates whether Newspack blocks are supported for this post type. | |
| HasSupportsPageAttributes | Bool | Indicates whether page attributes, such as order or parent, are supported. | |
| HasSupportsPostFormats | Bool | Indicates whether post formats are supported, allowing authors to classify content by format. | |
| HasSupportsPublicize | Bool | Indicates whether Jetpack Publicize integration is supported. | |
| HasSupportsRevisions | Bool | Indicates whether revisions are supported for this post type. | |
| HasSupportsSlug | Bool | Indicates whether a URL slug is supported for this post type. | |
| HasSupportsTags | Bool | Indicates whether tags are supported for this post type. | |
| HasSupportsThumbnail | Bool | Indicates whether featured images (thumbnails) are supported for this post type. | |
| HasSupportsTitle | Bool | Indicates whether titles are supported for this post type. | |
| HasSupportsTrackbacks | Bool | Indicates whether trackbacks are supported for this post type. | |
| HasSupportsWpcomMarkdown | Bool | Indicates whether Markdown formatting is supported for this post type on WordPress.com. |