Support

Account

Home Forums General Issues Query not running as expected Reply To: Query not running as expected

  • Ok, so after some thought I had a feeling that I had to specify that I wanted to have both queries return true for it to display the relevant data. I adjusted my query to include a “relation” but still the incorrect results are showing for Coming Soon, and no results are pulling through for Now Showing.

    https://apexcinemas.andrewcourtney.co.uk/coming-soon/
    https://apexcinemas.andrewcourtney.co.uk/now-showing/

    Below are the amended queries for each page:

    Coming Soon

        $comingSoonFilms = new WP_Query(array(
            'post_type' => 'film',
            'posts_per_page' => -1,
            'order' => 'ASC',
            'meta_query' => array(
                'relation' => 'AND',
                array(
                    'key' => 'film_releasedate',
                    'value' => $dateToday,
                    'type' => 'DATE',
                    'compare' => '>',
                ),
                array(
                    'key' => 'film_active',
                    'value' => '1',
                ),
            )
        ));

    Now Showing

        $nowShowingFilms = new WP_Query(array(
            'post_type' => 'film',
            'posts_per_page' => -1,
            'order' => 'DESC',
            'meta_query' => array(
                'relation' => 'AND',
                array(
                    'key' => 'film_releasedate',
                    'value' => $dateToday,
                    'type' => 'DATE',
                    'compare' => '<',
                ),
                array(
                    'key' => 'film_active',
                    'value' => '1',
                ),
            )
        ));

    If any other details would be helpful let me know!

    Thanks in advance.