Multiple Orderby values in WP_Query

morgan

I have the following query to get the data from custom post type.

$query = new WP_Query(array(
    'post_type' => 'wpgems',
    'nopaging' => true,
    'post_status' => array('publish', 'pending', 'future'),
    'meta_key' => 'wcu_dept',
    'meta_value' => 'SOME_VALUE',
    'orderby' => 'title',
    'order' => 'ASC'
));

Now I want to sort it with multiple values like title should be descending than another value ascending.

Jacob

You can use orderby with array value to apply multiple orderby values.

$query = new WP_Query(array(
    'post_type' => 'wpgems',
    'nopaging' => true,
    'post_status' => array('publish', 'pending', 'future'),
    'meta_key' => 'wcu_dept',
    'meta_value' => 'SOME_VALUE',
    'orderby' => array(
        'title' => 'DESC',
        'menu_order' => 'ASC'
    )
));

James

You can simply add the sorting column with only space to apply multiple values.

$query = new WP_Query(array(
    'orderby' => 'title menu_order',
    'order' => 'DESC'
));