[Resuelto] Single line custom field filter using checkbox not working properly

[Autor]

Mensajes

[marcB-6]

I am trying to: add Single line custom field filter using checkbox

Link to a page where the issue can be seen:enlace oculto click on filters

I expected to see: for example, if i click on "Amsterdam" then it will give perfect results, but when I click "Bussum" with "Amsterdam" selected it says no results found.It should give results from "Amsterdam" and "Bussum" as it is checkbox filter.

Thanks

[Nigel]

Hi Marc

These are individual checkbox fields inserted as filters, right?

By default they are inserted with an 'AND' relationship, i.e. posts must match ALL of the checked fields.

You'll need to change that to 'OR', so that the requirement is that posts match ANY of the checked fields.

See the screenshot.

If you can't see the Query Filter section in your View you'll need to expose it via the Screen Options tab at the very top of the page.

[marcB-6]

Hi Nigel,

I have only 1 filter set.see attached screenshot.

Thanks!

[Nigel]

OK, sorry, it's a checkboxes field, not several checkbox fields, yes?

Can you check the settings for the field in Toolset > Post Fields.

What do you have for the save option?

[marcB-6]

OK, sorry, it's a checkboxes field, not several checkbox fields, yes?
Ans : Yes
See attached screenshot

[Nigel]

Hi Marc

Sorry, I misunderstood how you have this set up.

You have a single line text field, which you are displaying as checkboxes in the filter.

The resulting query uses and AND comparison when multiple values are checked, and in this case there is no option to change that.

To make this an OR comparison you would need to use the wpv_filter_query filter and hook into this View and manually override the relation argument of the meta_query to "OR".

If you don't want to add code to your site, make a field type that is a checkboxes field (or use a taxonomy which makes for more efficient queries when used as filters in any case) and then it will function as required.

[marcB-6]

I can not change field type.

To make this an OR comparison you would need to use the wpv_filter_query filter and hook into this View and manually override the relation argument of the meta_query to "OR".
Comment : Will it work for the view I have shown you? As it is single line field.

[Nigel]

Yes.

If you turn on debug mode for Views (Toolset > Settings > Front-end Content) and reload the page with two of the options selected you will see in the wpv_filter_query section the meta_query used by Views to retrieve the posts, and the relation will be set to AND.

Use wpv_filter_query to change that to OR.

[marcB-6]

Hi Nigel,

I tried with meta_query "OR" relation using below code. But it was not working properly then I played with the filter settings itself and fount solution.

add_filter( 'wpv_filter_query', 'prefix_change_vacature_filter', 99, 3 );
function prefix_change_vacature_filter( $query_args, $settings, $view_id ) {
    //global $current_user;
    if($view_id == 597){ 
        $query_args = array(
        'post_type' => 'vacature',
        'posts_per_page' => -1,
        'post_status' => 'publish',
        'meta_query' => array(
        'relation' => 'OR'
	),
      );
    }
    return $query_args;
}

I am attaching screenshot for the filter setting. It would help others 🙂

Thanks for your support.

[Nigel]

Hi Marc

I'll admit to being puzzled as to why what you have done works, but I'm not surprised your code didn't work, it doesn't do what's required.

If expected it to look more like this:

add_filter( 'wpv_filter_query', 'prefix_change_vacature_filter', 101, 3 );
function prefix_change_vacature_filter( $query_args, $settings, $view_id ) {

    if ( $view_id == 597 && isset( $query_args['meta_query'] ) ) { 
        $query_args['meta_query']['relation'] = 'OR';
    }
    return $query_args;
}

Anyway, thanks for sharing your findings with us.

[marcB-6]

Thanks Nigel!!