Multiple Custom Field Query

Question

I have a unique situation where I need to filter on 2 custom fields where 1st field is expiry and values of "" and greater than todays date are valid and 2 field is a number which should be greater than some value. So Ideally I need to put a OR relation for 2 possibilities of 1st field with and between 1st field and second field.

Any help in this regard will be highly appreciated.

Answer 1

that should be fairly simple using Meta_Query parameter of the WP_Query object

you can set the relation and set as many fields as you like:

$args = array(
'meta_query' => array(
        'relation' => 'OR', //realation 
        array(
            'key' => 'color', //first custom field
            'value' => 'blue',
            'compare' => 'NOT LIKE'
        ),
        array(
            'key' => 'price', //second custom field
            'value' => array( 20, 100 ),
            'type' => 'numeric',
            'compare' => 'BETWEEN'
        )
    )
);

$query = new WP_Query( $args );