[Resolved] Orderby two custom fields in the same View

[Author]

Posts

[thibaultS]

I have created a view displaying all the committee members, named 'committee_members'. The custom content type used by this view has two fields named 'begin_date' and 'function'

I am trying to:
ordered the members first by function (lower numerical value first) and if two members have the same function (so same number), displaying member with the lower begin_date before.

In the view i can only order by one custom field. If i include a shortcode to a page for displaying this view i can add orderby attribute, but this attribute seems to change nothing.

[wpv-view name="committee_members" orderby="wplc-function,wplc-begin_date" order="asc"]

[Christian Cox]

This is tricky because it's not possible to do in wp-admin. You must use custom code to modify the Query. Add this code to your child theme's functions.php file:

add_filter( 'wpv_filter_query', 'order_by_two_custom_fields',199,3 );
function order_by_two_custom_fields( $query_args, $views_settings, $view_id) {
  $view_ids = array( 12345 );
  $args = array();
  if (in_array($view_id, $view_ids)){
    $args = array(
      'meta_query' => array(
        'relation' => 'AND',
        'function-clause' => array(
          'key' => 'wpcf-function',
          'compare' => 'EXISTS',
          'type' => 'NUMERIC'
        ),
        'begin-clause' => array(
          'key' => 'wpcf-begin_date',
          'compare' => 'EXISTS',
          'type' => 'NUMERIC'
        )
      ),
      'orderby' => array(
        'function-clause' => 'ASC',
        'begin-clause' => 'ASC'
      )
    );
  }
  return array_merge($query_args, $args);
}

Replace 12345 with the numeric ID of this View.

[thibaultS]

I just need to add :

  $args = array();

before the if otherwise it generates error with other views.

[Christian Cox]

Ah, good catch. I have updated the code sample above.