PostCounts
Get number of posts in the post type groups by post status.
Stored Procedure Specific Information
Execute
Call this procedure to get number of posts in the post type groups by post status.
To get number of posts in the post type groups by post status, you must specify the following column: PostType.
For example:
EXEC PostCounts PostType='post';
Input
| Name | Type | Description |
| PostType | String | Specifies the WordPress post type to analyze, such as post, page, or custom post type. |
Result Set Columns
| Name | Type | Description |
| Success | String | Indicates whether the post count retrieval operation completed successfully. |
| CountsAllPublish | String | Returns the total number of published posts across all users for the specified post type. |
| CountsAllDraft | String | Returns the total number of draft posts across all users for the specified post type. |
| CountsMinePublish | String | Returns the total number of published posts created by the current authenticated user. |