Reply To: Querying with meta query on true/false field

• rudtek

• August 18, 2021 at 1:40 am

This is how I got it to work, but it seems there should be an easier way?

$event_query = new WP_Query(     
    array(
        'post_type' => 'al_event',
        'orderby' => 'menu_order',
        'order' => 'ASC',
        'meta_query' => array(
            array(
                'key'     => 'event_date_end',
                'compare' => '>=',
                'value'   => $today,
            ),
            array(
                'key'     => 'event_date',
                'compare' => '<=',
                'value'   => $future,
            ),
            array(
                'relation' => 'OR',
                array(
                    'key' => 'hide_on_public_page',
                    'value' => '0'
                ),
                array(
                    'key' => 'hide_on_public_page',
                    'compare' => 'NOT EXISTS', 
                )
            )
        ),
    ) );