Using pre_get_posts to filter only posts that include all values

• matteoc5

• October 8, 2017 at 9:49 am

Hello, I have everything setup and working as far as filtering my custom post types in archives. Right now though, when I check multiple values it will return any post that has any of the values. So if I check ‘female’ with ‘black hair’ it should only bring up females with black hair not any post that has either of those values. So if I check ‘female’ that has ‘black hair’ and is ‘caucasian’ and lives in ‘St. Louis’. the only posts that should show up are ones that include all those values.

Here is my pre_get_posts function I have so far:

function my_pre_get_posts( $query ) {

// bail early if is in admin
if( is_admin() ) {
return $query;
}

// bail early if not main query
// – allows custom code / plugins to continue working
if( !$query->is_main_query() ) return $query;

if (isset($query->query_vars[‘post_type’]) && $query->query_vars[‘post_type’] == ‘models’) {

foreach ($GLOBALS[‘my_query_filters’] as $key => $name) {

$values = explode(‘,’, $_GET[$name]);

if (isset($_GET[$name])) {

$query->set(‘meta_key’, $name);
$query->set(‘meta_value’, $values);
}
}
}

return $query;
}

Thanks in advance

• matteoc5

• October 9, 2017 at 6:44 am

Please disregard my post. I have actually figured this out. thanks

• matteoc5

• October 9, 2017 at 6:45 am

FYI function should look like this:

// bail early if is in admin
if( is_admin() ) {
return;
}

// bail early if not main query
// – allows custom code / plugins to continue working
if( !$query->is_main_query() ) return;

// get meta query
$meta_query = $query->get(‘meta_query’);

$meta_query = array(
‘relation’ => ‘AND’,
);
foreach ($GLOBALS[‘my_query_filters’] as $key => $name) {

if (!empty($_GET[$name])) {

$values = explode(‘,’, $_GET[$name]);

$meta_query[] = array (
‘key’ => $name,
‘value’ => $values,
‘compare’ => ‘IN’,
);

}
}

$query->set(‘meta_query’, $meta_query);

return;

• Zaheer Abbas

• March 7, 2022 at 3:57 pm

Hi @matteoc5,
I have some type of code for the custom post type, but it is not working can you please help? No order found.

`
function citywise_post_filter( $query ) {

if( !$query->is_main_query() ) return;

if(isset(wp_get_current_user()->roles[0]) && wp_get_current_user()->roles[0] == ‘order_manager’){
$user_id = get_current_user_id();
$zip_code = esc_attr( get_the_author_meta( ‘zip_codes’, $user_id ) );

$meta_query = $query->get(“meta_query”);
$meta_query = array(
“relation” => “AND”,
);

$query->set(‘post_type’, ‘shop_order’ );

foreach (explode(“,”, $zip_code) as $code) {
$meta_query[] = array(
‘key’=>’_billing_postcode’,
‘value’=>$code,
‘compare’ => ‘IN’,
);
}

$query->set(‘meta_query’, $meta_query );

}

return $query;
}