Reply To: Exclude posts from main loop based on ACF field value

• juxprose

• October 30, 2017 at 7:32 pm

Using 'compare' => 'NOT EXISTS' instead of 'compare' => '!=' seems to return all posts and exclude the meta_query.

function exclude_featured_post( $query ) {
    if ( $query->is_home() && $query->is_main_query()) {
        // in case for some reason there's already a meta query set from other plugin
        $meta_query = $query->get('meta_query')? : [];

        // append yours
        $meta_query[] = [
            'key' => 'featured_post',
            'value' => '1',
            'compare' => 'NOT EXISTS'
        ];

        $query->set('meta_query', $meta_query);

      	//echo '<pre>'; print_r( $query ); echo '</pre>';

    }
}
add_action( 'pre_get_posts', 'exclude_featured_post' );

From here: https://core.trac.wordpress.org/ticket/18158