[Resolved] Filter multiple custom fields with OR

[Author]

Posts

[henriqueD]

Hello, how is everything?

I have a problem that I can't solve and I need your help.

I have a very simple CPT, with some custom fields.

I set up the views correctly and this view has a single field that should search between some custom fields.

The view must search using the OR parameter, however, the selection box does not appear, so I change from AND to OR. same in the attached image.

I use the legacy views plugin and everything is up to date in the latest version, I even created a test environment from scratch, but even with the minimum plugin and the default WP theme, it doesn't work.

I need help urgently.

I'm waiting.

Thanks

[Waqar]

Hi,

Looks like this is the same requirement that was discussed in your other recent ticket.
( ref: https://toolset.com/forums/topic/user-view-with-or-in-the-query-filter/#post-2234021 )

Have you tried the code from my reply to set the custom field filter relation operator to "OR"?

regards,
Waqar

[henriqueD]

it's the same ticket, it's just that I couldn't find the old one and opened a new one.

but man... this is essential, and as I said, even in a pure wp installation with the default theme it doesn't work.

I have more than 10 projects to deliver by the end of the year and they all use views.

doing this work in so many, it's bad for me later.

the problem is that you guys even broke the functionality, and there is no deadline to fix it, then it gets really bad like that.

there is no way to request a maximum priority in this case? this must be affecting many other professionals, as it is an elementary function.

I'm waiting.

[Waqar]

I can understand your concern, but, as I mentioned in the other ticket, this is already highlighted.

I've already added your voice to this matter and will keep you updated on the progress through this ticket.

You can also directly share your feedback about the importance of this feature, using the form on this page:
https://toolset.com/home/contact-us/suggest-a-new-feature-for-toolset/

[henriqueD]

Hello how are you?

this code that you sent me, is it only for posts?

I have several views with users too.

can you send me an example code that works for users?

I'm waiting

thanks

[Waqar]

The code will remain the same for the user views, too.

The only difference would be that the filter "wpv_filter_query" will be replaced with the filter "wpv_filter_user_query":
( ref: https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_user_query )

add_filter( 'wpv_filter_user_query', 'wpv_filter_query_func', 1000 , 3 );
function wpv_filter_query_func( $query_args, $view_settings ) {
    // process if specific view
    if ( ( isset($view_settings['view_id']) && $view_settings['view_id'] == 1234) ) {
        if( !empty($query_args['meta_query']) ) {
            $query_args['meta_query']['relation'] = 'OR';
        }
    }
    return $query_args;
}