Nested meta_query with multiple relation keys

Question

I am curious whether Wordpress is able to run nested meta_query, with each having different relation keys? As of Wordpress 3.0, tax_query is able to perform this function; I'm wondering whether this has an equivalent with meta_query.

$results = query_posts( array(
    'post_type' => 'event_id',
    'meta_query' => array(
        'relation' => 'AND',
        array(
            'relation' => 'OR',
            array(
                'key' => 'primary_user_id',
                'value' => $user_id
            ),
            array(
                'key' => 'secondary_user_id',
                'value' => $user_id
            )
        ),
        array(
            'key' => 'date',
            'value' => array( $start_date, $end_date ),
            'type' => 'DATETIME',
            'compare' => 'BETWEEN'
        )
    )
) );

References:

Mayur Chauhan · Accepted Answer · 2020-02-17 05:15:36Z

34

The question was for Wordpress 3.0, but just in case someone has the same question for a more recent version, from Wordpress Codex:

"Starting with version 4.1, meta_query clauses can be nested in order to construct complex queries."

https://developer.wordpress.org/reference/classes/wp_query/#custom-field-post-meta-parameters So, that query should work on the current Wordpress version.

edited Feb 17, 2020 at 5:15

Mayur Chauhan

3513 silver badges8 bronze badges

answered Mar 19, 2015 at 18:01

Gustavo Daniel

1,5561 gold badge11 silver badges9 bronze badges

Add a comment |

Ramon Fincken · Accepted Answer · 2021-08-03 19:02:56Z

19

Meanwhile this is possible, see documentation with example and explanation:

Old link: https://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters Update: 2021, new link: https://developer.wordpress.org/reference/classes/wp_query/#custom-field-post-meta-parameters

and another example https://wordpress.org/support/topic/wp_query-with-multiple-meta_query/#post-9410992

'meta_query'  => array(
    'relation' => 'OR',
    array(
        'relation' => 'AND',
        array(
            'key'     => '_price',
            'value'   => 1,
            'compare' => '>=',
            'type' => 'DECIMAL',
        ),
        array(
            'key'     => '_price',
            'value' => 3000,
            'compare' => '<=',
            'type' => 'DECIMAL',
        ),
    ),
    array(
        'relation' => 'AND',
        array(
            'key'     => '_price',
            'value'   => 3001,
            'compare' => '>=',
            'type' => 'DECIMAL',
        ),
        array(
            'key'     => '_price',
            'value' => 6000, //fixed <= to =>
            'compare' => '<=',
            'type' => 'DECIMAL',
        ),
    )
),

edited Aug 3, 2021 at 19:02

answered Aug 7, 2018 at 9:34

Ramon Fincken

3552 silver badges8 bronze badges

This is also a good reference but I apprecaite the full description here too developer.wordpress.org/reference/classes/wp_query/…

shaneonabike
– shaneonabike

2021-06-11 13:59:25 +00:00
Commented Jun 11, 2021 at 13:59
The codex.wp is beeing moved to developer.wp so yes I did add the correct reference at the time. At this moment in time is is indeed developer.wordpress.org/reference/classes/wp_query/… i

Ramon Fincken
– Ramon Fincken

2021-06-15 12:11:52 +00:00
Commented Jun 15, 2021 at 12:11
How do I add three conditions with an "AND"?

Si8
– Si8

2021-12-21 00:21:41 +00:00
Commented Dec 21, 2021 at 0:21
@Si8 one AND would suffice for adding A AND B AND C . the AND is one level higher then the others

Ramon Fincken
– Ramon Fincken

2023-11-10 14:26:57 +00:00
Commented Nov 10, 2023 at 14:26

Add a comment |

vmassuchetto · Accepted Answer · 2013-01-18 13:02:31Z

That seems to be impossible. Please someone correct me if I'm wrong.

The meta_query parameter will actually be transformed into a WP_Meta_Query object, and the relation verification won't go deeper in wp-includes/meta.php, and occurs just once in the top level:

if ( isset( $meta_query['relation'] ) && strtoupper( $meta_query['relation'] ) == 'OR' ) {
    $this->relation = 'OR';
} else {
    $this->relation = 'AND';
}

A possible solution for this is to build your own JOIN for this query.

$query = new WP_Query( array(
    ...
    'my_meta_query' => true,
    'suppress_filters' => false
) );

add_filter( 'posts_join', 'my_meta_query_posts_join', 10, 2 );
function my_meta_query_posts_join( $join, $query ) {

    if ( empty( $query->query_vars['my_meta_query'] ) )
        return $join;

    global $wpdb;

    $new_join = "
        INNER JOIN {$wpdb->postmeta} pm1 ON 1=1
            AND pm1.post_id = {$wpdb->posts}.ID
            AND pm1.meta_key = '_some_meta_key'
            AND pm1.meta_value = 'some_value'
    ";

    return $join . ' ' . $new_join;
}

And if you need further verifications and rules, you can also use the posts_where filter.

Seems to be the same approach @scribu recommends on Core Trac: core.trac.wordpress.org/ticket/20312 — Andrew Odri
– Andrew Odri, Commented May 29, 2014 at 19:49

Stack Exchange Network

Nested meta_query with multiple relation keys

3 Answers 3

Your Answer

Linked

Hot Network Questions

Nested meta_query with multiple relation keys

3 Answers 3

Your Answer

Sign up or log in

Post as a guest

Linked

Related

Hot Network Questions