Meta_query annidata con più chiavi di relazione

Question

Meta_query annidata con più chiavi di relazione

23

57168 2012-12-05

Sono curioso di sapere se Wordpress èin grado dieseguire meta_querynidificato,ognuno con chiavi di relazione diverse? Apartire da Wordpress 3.0,tax_query èin grado dieseguire questafunzione; Mi chiedo se abbia unequivalente con 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'
        )
    )
) );

Riferimenti:

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:

3 risposta

voti

9

2013-01-18

Sembraimpossibile. Perfavore,qualcunomi corregga se sbaglio.

Ilparametro meta_query verràeffettivamentetrasformatoin un oggetto WP_Meta_Querye la verifica della relationnon andràpiùin profonditàin wp-includes/meta.php e si verifica solo una volta al livello superiore:

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

Unapossibile soluzioneper questo è creareiltuo JOINper questa 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;
}

E se haibisogno di ulteriori verifichee regole,puoi anche utilizzareilfiltro posts_where.

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.

Sembraessere lo stesso approccio che @scribu consiglia su Core Trac: https://core.trac.wordpress.org/ticket/20312

Seems to be the same approach @scribu recommends on Core Trac: https://core.trac.wordpress.org/ticket/20312
- 3
- 2014-05-29
- Andrew Odri
@AndrewOdri è lo stessomanon lo è=)

@AndrewOdri it's the same but it's not =)
- 0
- 2015-10-06
- vmassuchetto

3

2018-08-07

Nelfrattempo questo èpossibile,vedere la documentazione conesempioe spiegazione:

https://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters

e un altroesempio 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',
        ),
    )
),

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

https://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_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',
        ),
    )
),

Gustavo · Accepted Answer · 2015-03-19

23

2015-03-19

La domandaeraper Wordpress 3.0,manel caso qualcuno avesse la stessa domandaper una versionepiù recente,da Wordpress Codex:

"Apartire dalla versione 4.1,le clausolemeta_querypossonoesserenidificateper costruire query complesse."

https://developer.wordpress.org/reference/classes/wp_query/# custom-field-post-meta-parameters Quindi,quella query dovrebbefunzionare sulla versione corrente di Wordpress.