get_private_posts_cap_sql( string|array $post_type )

Retrieve the private post SQL based on capability.

Description

This function provides a standardized way to appropriately select on the post_status of a post type. The function will return a piece of SQL code that can be added to a WHERE clause; this SQL is constructed to allow all published posts, and all private posts to which the user has access.

Parameters

$post_type

(string|array) (Required) Single post type or an array of post types. Currently only supports 'post' or 'page'.

Return

(string) SQL code that can be added to a where clause.

Source

File: wp-includes/post.php

function get_private_posts_cap_sql( $post_type ) {
	return get_posts_by_author_sql( $post_type, false );
}

Changelog

Version Description
4.3.0 Added the ability to pass an array to $post_type.
2.2.0 Introduced.

© 2003–2021 WordPress Foundation
Licensed under the GNU GPLv2+ License.
https://developer.wordpress.org/reference/functions/get_private_posts_cap_sql