[Resolved] In a view, show only posts that DONT have a date field set.

[Author]

Posts

[davidS-53]

I am trying to: show all posts that DONT have a value set for custom field expiry-date.

I can show all posts that DO have this field set by using "Select items with field: Expiry Date is a string different from" (as in different from blank)

However, the opposite "Select items with field:Expiry Date is a string equal to" (as in equal to blank) doesn't work. Perhaps I;m missing something here?

[Minesh]

Hello. Thank you for contacting the Toolset support.

Well - here you need to make sure that does meta_key exists for the posts where the custom date field expiry-date is NOT set in the database table postmeta. If No:

You need to use view's filter: wpv_filterP_query

add_filter( 'wpv_filter_query', 'func_expirt_date_not_exists_posts', 10, 3 );
function func_expirt_date_not_exists_posts( $query_args, $view_settings, $view_id ) {
    if($view_id == 999999) {
        $query_args['meta_query'][] = array(
            'key'     => 'wpcf-expiry-date',
            'compare' => 'NOT EXISTS',
        );
    }
    return $query_args;
}

Where:
- Replace 999999 with your original view ID

More help:
=> https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query

If solution shared above is the actual case and works for you. We encourage you to file a feature request here for this case with the following link:
=> https://toolset.com/home/contact-us/suggest-a-new-feature-for-toolset/

[davidS-53]

Thanks- however I had to use

if($view_settings['view_id'] == 9999){

Instead of

if($view_id = 9999) {

Your code applied the filter to every view for some reason.