This thread is resolved. Here is a description of the problem and solution.
Problem:
I want to have the checkboxes filter selection logic to be AND instead of the default OR.
Solution:
By default, the filter logic is OR. If you want to have AND you need to use the "wpv_filter_query". (It is considered as a custom coding and outside of the support scope)
Example:
add_filter( 'wpv_filter_query', 'we_custom_search_criteria', 101, 3 );
function we_custom_search_criteria( $query_args ,$view_settings ) {
$view_id = 3142; // set view id (wpv_view_count)
if ( isset( $view_settings['view_id'] ) && $view_settings['view_id'] == $view_id ) {
foreach( (array)$query_args['meta_query'] as $k => $v ) :
if( isset( $v['relation'] ) && $v['relation'] == 'OR' ) {
$query_args['meta_query'][$k]['relation'] = 'AND';
}
endforeach;
}
return $query_args;
}
Relevant Documentation:
https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
This topic contains 7 replies, has 2 voices.
Last updated by 3 years, 7 months ago.
Assisted by: Christopher Amirian.
Tell us what you are trying to do?
1. Go to hidden link
2. Select "Plant Nutrition" under "Filter by Product Type" drop down.
3. Check "Nitrogen (N)". See the result count is 207.
4. Check "Application: Foliar". See the result count is 255.
If I set "equal to" in query filter, it should be OR , right?
It seems like it will filter as AND. (If I select 2 checkbox, it should decrease the result count.)
I even tested "in", I got exactly same result.
Is there any documentation that you are following?
https://toolset.com/forums/topic/filter-with-custom-field-checkboxes-that-compare-using-or-instead-of-and-in-view/
Is there a similar example that we can see?
No
What is the link to your site?
hidden link
