How do I use a tax_query and a meta_query in wordpress succesfully?

Question

This is the code I am using:

$results = array(
                'post_type' => 'score',
                'tax_query' => array(
                    array(
                        'taxonomy' => 'competitions',
                        'field' => 'slug',
                        'terms' => $tax->slug,
                        'compare' => '='
                    )
                ),
                'meta_query' => array(
                    array(
                        'numberposts'   => -1,
                        'post_type' => 'score',
                        'meta_key'     => 'horse_name',
                        'meta_value'   => $horsename,
                        'compare' => 'LIKE'
                    )
                )
           );

// query
$the_query = new WP_Query($results);

The problem is I can't work out how to make a Boolean AND expression so that both the taxonomy and the custom field should match before returning a post.

score 0 · Answer 1 · answered May 18 '21 at 06:57

0

I revised your code. check below code.

$results = array(
    'post_type'        => 'score',
    'posts_per_page'   => -1,
    'tax_query'        => array(
        array(
            'taxonomy' => 'competitions',
            'field'    => 'slug',
            'terms'    => $tax->slug,
            'compare'  => '='
        )
    ),
    'meta_query' => array(
        array(
            'meta_key'   => 'horse_name',
            'meta_value' => $horsename,
            'compare'    => 'LIKE'
        )
    )
);
// query
$the_query = new WP_Query( $results );

answered May 18 '21 at 06:57

Bhautik

11,125
3
16
38

That doesn't seem to change anything with regard to making the expression a boolean AND. I need to select the posts based on the taxonomy term and on a custom field term. – M1 Creative Developer May 18 '21 at 07:19
I fix your code. you are passing `'numberposts' => -1, and 'post_type' => 'score',` in meta. query that's wrong. – Bhautik May 18 '21 at 07:23
Thank you, but it still doesn't solve my problem that I need the AND combination of the taxonomy and the custom field – M1 Creative Developer May 18 '21 at 07:33
You can not add `AND` between `tax_query` and `meta_query` as per the current query this will display only those data that have tax slug you defined and meta value you pass. – Bhautik May 18 '21 at 07:36
Is there a way around this then? – M1 Creative Developer May 18 '21 at 07:44
if you have the correct value in database the this code should be work – Bhautik May 18 '21 at 07:57

How do I use a tax_query and a meta_query in wordpress succesfully?

1 Answers1