Reply To: An advanced meta_query looking for multiple custom field values

• James

• January 8, 2016 at 4:49 pm

Hi @jack1,

I believe you can use this query:

$meta_query = array(
    'meta_query' => array(
        'relation' => 'OR',
        array(
            'relation' => 'AND',
            array(
                'key' => 'custom_field',
                'value'   => '',
                'compare' => 'NOT IN'
            ),
            array(
                'key' => 'custom_field2',
                'value'   => '',
                'compare' => 'NOT IN'
            ),
        ),
        array(
            'relation' => 'AND',
            array(
                'key' => 'custom_checkbox',
                'value'   => true,
                'compare' => 'NOT LIKE'
            ),
            array(
                'key' => 'custom_checkbox2',
                'value'   => true,
                'compare' => 'NOT LIKE'
            ),
        ),
    ),
);    

To learn more about meta_query, please take a look at this page: https://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters

I hope this helps.