Query Improvements in the Latest Versions of WordPress

Within the last year, much has been written about the improvements to the WordPress user interface: the most talked about change has been the improved writing experience.

But if you're a developer you'll be wanting to know less about that and more about what's changed under the hood. Here I'll demonstrate one of the most interesting changes for developers: improvements to certain types of queries.

The main changes are as follows:

• Support for nested queries has been added for queries on post metadata, dates, and taxonomy terms.
• Extra parameters have been added for querying comments.
• And some bugs have been fixed too!

Let's have a look at the changes.

Nested Queries

In previous versions of WordPress, you could use an AND or OR statement to define queries for taxonomy terms, dates, and metadata. So for example, the following arguments will be used in a query on a recipe site which outputs quick breakfast recipes:

<?php

$args = array(
    'post_type' => 'post',
    'tax_query' => array(
        'relation' => 'AND',
        array(
            'taxonomy' => 'speed',
            'field' => 'slug',
            'terms' => array( 'quick' )
        ),
        array(
            'taxonomy' => 'meal',
            'field' => 'slug',
            'terms' => array( 'breakfast' )
        )
    )
);

$query = new WP_Query( $args );

?>

This looks for the 'speed' and 'meal' taxonomies and outputs posts with the 'quick' and 'breakfast' terms respectively.

But what if you wanted to write a more complex query? Let's say you wanted quick recipes for breakfast and slow recipes for lunch (maybe for someone who wants to get breakfast done quickly so they have more time to cook lunch!). You don't want to use a simple AND statement to join all the elements of your query, since then you would get slow recipes for breakfast and lunch, for example. And you don't want to use an OR statement linking all the terms, as you'll get all manner of recipes which only have one of the queried terms along with other ones you want to filter out.

The good news is that now you can do this. To query quick recipes for breakfast and slow recipes for lunch, you'd use the following:

<?php

$query = new WP_Query(
    array(
        'tax_query' => array(
            'relation' => 'OR',
            array(
                'relation' => 'AND',
                array(
                    'taxonomy' => 'meal',
                    'field' => 'slug',
                    'terms' => array( 'breakfast' )
                ),
                array(
                    'taxonomy' => 'speed',
                    'field' => 'slug',
                    'terms' => array( 'quick' )
                )
            ),
            array(
                'relation' => 'AND',
                array(
                    'taxonomy' => 'meal',
                    'field' => 'slug',
                    'terms' => array( 'lunch' )
                ),
                array(
                    'taxonomy' => 'speed',
                    'field' => 'slug',
                    'terms' => array( 'slow' )

                )
            )
        )
    )
);

$query = new WP_Query( $args );

?>

Here I've used two nested arrays:

• The outer array uses OR, because we're looking for posts which are either quick breakfast recipes or slow lunch recipes.
• The first nested array looks for posts which are quick breakfast recipes, using AND because you want the post to have both terms.
• The second nested array looks for slow lunch recipes, again using AND.

Of course you could vary your queries to include multiple taxonomy terms and values, and get as complex as you need.

Applying Nested Queries: Taxonomy Terms, Metadata, and Dates

The example I've given above uses taxonomy terms, but this feature has also been added to date and metadata queries. Metadata is potentially where things could get interesting, as you have the scope for so many values.

The syntax works in exactly the same way for date and metadata queries. For meta queries you replace tax_query with meta_query and use 'key' and 'value' as the parameters. For date queries you replace tax_query with date_query and use the date parameters provided in the WordPress Codex.

Comment Parameters

To query comments, you use the WP_Comment_Query class in place of the more commonly used WP_Query class. This class has had eight new parameters added to it:

• 'author__in': identify comment author (or an array of authors)
• 'author__not_in': identify comments not by a certain author (or array of authors)
• 'post_author__in': identify author (or array of authors) of the post the comment was made on
• 'post_author__not_in': exclude comments made on posts written by particular author or array of authors
• 'comment__in': comments with a certain ID or array of IDs
• 'comment__not_in': exclude comments with a certain ID or array of IDs
• 'post__in': comments made on a post or array of posts (using the post ID)
• 'post__not_in': exclude comments made on a post or array of posts (using the post ID)
  

The values used for these are the author ID, comment ID or post ID as appropriate.

Note that the WP_Comment_Query class now supports nested queries as well.

Bug Fixes

There have also been a couple of bug fixes which you might find helpful:

• A bug that caused queries to fail when a date_query was used along with a tax_query or meta_query has been fixed.
• When ‘orderby' => 'meta_value’ was used when passing a 'meta_query' with the OR relation  in WP_Query, this used to break the query. This has been fixed.
  

If you want the lowdown on all the details, you can find it on the make WordPress core site.

Summary

These improvements to queries take WordPress a step further to full CMS capability. The ability to use nested queries means that you can output content in much more flexible and complex ways. It will be interesting to see how people use them!

by Rachel McCollin via Tuts+ Code