Custom post status filter links always show a count of all posts in the site with that status, not the logged in users count

Question

I have a custom post status and the issue I have is that the filter option for it that automatically appears above the post listings on the edit.php page of the WP admin shows a total count of all the posts with this status. I want it to show a count that is specific to the user in question.

So for example

All (1) | Published (0) | Draft (0) | Pending (0) | | Trash (0) | Awaiting (8)

That figure of 8 for awaiting is all the posts in the system with the status, yet the user I'm logged in at, if they had no posts set to that status I would want that to appear with zero or to not be visible at all (the default functionality in WP I believe).

I can't see if this is functionality supported by WP but I assume there must be a way as the other totals listed in the filter links ARE user specific.

This is all setup via the simple register_post_status function....

function awaiting_custom_post_status(){
    register_post_status( 'awaiting', array(
        'label'                     => _x( 'Changes Awaiting Approval', 'apartments' ),
        'public'                    => true,
        'exclude_from_search'       => false,
        'show_in_admin_all_list'    => true,
        'show_in_admin_status_list' => true,
        'label_count'               => _n_noop( 'Changes Awaiting Approval <span class="count">(%s)</span>', 'Changes Awaiting Approval <span class="count">(%s)</span>' ),
    ) );
}
add_action( 'init', 'awaiting_custom_post_status' );

Anyone got any ideas how to modify this count value to be user specific such as the other values are?

Answer 1

Edit: Just to credit the original, I'm fairly sure [this] is where I grabbed it from. Seems a quick search shows stackexchange is full of modifications of the same/ish code. But as the comments are spot on, I'd say all the credit goes to @W van Dam

I had a similar setup with multiple users who only saw their own posts but I have not worked with custom post statuses at all.

This is an old code snippet from an old project, but maybe it's of some use

add_filter('wp_count_posts', function($counts, $type, $perm) {
    global $wpdb;

    // We only want to modify the counts shown in admin and depending on $perm being 'readable' 
    if (!is_admin() || 'readable' !== $perm) return $counts;

    // Only modify the counts if the user is not allowed to edit the posts of others
    $post_type_object = get_post_type_object($type);
    if (current_user_can( $post_type_object->cap->edit_others_posts ) ) {   return $counts; }

    $query = "SELECT post_status, COUNT( * ) AS num_posts FROM {$wpdb->posts} WHERE post_type = %s AND (post_author = %d) GROUP BY post_status";
    $results = (array) $wpdb->get_results($wpdb->prepare( $query, $type, get_current_user_id() ), ARRAY_A);
    $counts = array_fill_keys(get_post_stati(), 0);

    foreach ($results as $row) { $counts[ $row['post_status'] ] = $row['num_posts']; }
    return (object) $counts;
}, 10, 3);

And the reason I asked about the posts they were seeing because I'm fairly sure this'll edit the counts to show only their own posts.

Answer 2

Here's a way to additionally filter the Awating status view by the current user:

add_action( 'pre_get_posts', function( \WP_Query $q )
{
    // Only target the edit.php admin page
    if( ! did_action( 'load-edit.php' ) )
        return;

    // Only target the main query
    if ( ! $q->is_main_query() )
        return;

    // Only target the 'post' post type
    if ( 'post' !== $q->get( 'post_type' ) )
        return;

    // Only target the 'awaiting' post status
    if ( 'awaiting' !== $q->get( 'post_status' ) )
        return;

    // Only fetch posts created by the current user     
    $q->set( 'author', get_current_user_id() );

} );

PS: I removed the views_edit-{$post_type} filtering part as it had problems, as it only counted correctly when the Awaiting link was clicked on. I just noticed it when I tested it ;-) But the idea was to avoid having an extra counting query and reuse the main query for counting. As a workaround we could of course only display the modified counting when the Awaiting status is filtered, otherwise remove it for that status , but it's probably better to keep the current UX. So for that part you could instead check out the alternative approach suggested by @imihenrik.

Hope it helps!