dlovas
9/28/2017 - 12:25 PM

Combined meta_query Queries

Combined meta_query Queries

SRC:
https://wordpress.stackexchange.com/questions/72894/how-can-i-combine-meta-query-queries

OR
***
https://stackoverflow.com/questions/18401879/meta-query-how-to-search-using-both-relation-or-and
$meta_query_args = array(
    'meta_key' => 'price',
    'meta_value_num' => 1000,
    'meta_compare' => '<=',
    'meta_query' => array(
        'relation' => 'OR',
        array(
            'key' => 'roomcount',
            'value' => 3,
            'type' => 'numeric',
            'compare' => '>='
        ),
        array(
            'key' => 'bathroomcount',
            'value' => 2,
            'type' => 'numeric',
            'compare' => '>='
        )
    )
);

$realestate_meta_query = new WP_Query( $meta_query_args );
$args => array(
    'relation' => 'AND',
    array(
        'key' => array('title','author','genre',),
        'value' => $searchvalue,
        'compare' => '='
    ),
    array(
        'key' => 'rating',
        'value' => $ratingvalue,
        'compare' => '=',
        'type' => 'NUMERIC'

    )
)