How to sort by two meta keys in admin area?

I can’t find any examples that combine the $query->set('property', 'value') syntax with an array assuming that’s the correct method

In your $args array, you defined both meta_query and orderby as arrays, and they are each an arg for WP_Query (or a value for the “property” above), hence in your custom function (set_post_order_in_admin()), just use $query->set( 'meta_query', <array> ) and $query->set( 'orderby', <array> ) like so:

// In the set_post_order_in_admin function:

// Replace these lines:
$query->set( 'meta_key', 'Order' );
$query->set( 'orderby', 'meta_value_num' );
$query->set( 'order', 'DESC' );

// with the following:

$query->set( 'meta_query', array(
    'relation'        => 'AND',
    'resume_order'    => array(
        'key'  => 'Order',
        'type' => 'NUMERIC'
    ),
    'resume_suborder' => array(
        'key'  => 'Sub order',
        'type' => 'NUMERIC'
    ),
) );

$query->set( 'orderby', array(
    // <orderby>      => <order>
    'resume_order'    => 'DESC',
    'resume_suborder' => 'ASC'
) );

Or did you mean something else?

Also, you should run your filter only if the current WP_Query is the main WordPress query to avoid your custom filter from messing with other WP_Query calls. So you would do if ( is_admin() && $query->is_main_query() ) instead of just if ( is_admin() ).

Related Posts: