How to Sorting / Order by multiple custom fields.

  • Resolved alessandroweb

    (@alessandroweb)


    11 years, 6 months ago

    How to display posts with ‘Event’ custom type ordered by ‘Start_Hour’ and then by ‘Start_Minute’?

    ‘Start_Hour’ and ‘Start_Minute’ are numeric custom fields.

    I tried this, but it doesn’t work:

    $args = array(
'post_type'=>'Events',
'orderby' => 'meta_value',
'meta_key' => 'Start_Hour Start_Minute',
'order' => 'ASC'
);
$loop = new WP_Query( $args );
Viewing 1 replies (of 1 total)
  • Thread Starter alessandroweb

    (@alessandroweb)

    11 years, 6 months ago

    Resolved by myself. Hope this helps.

    function orderbyreplace($orderby) {
    return str_replace('menu_order',
                       'mt1.meta_value, mt2.meta_value',
                       $orderby);
}

    and…

    $args = array(
  'post_type'=>'Events',
  'orderby' => 'menu_order',
  'order' => 'ASC',
  'meta_query' => array(
        array(
            'key' => 'Start_Hour',
            'value' => '',
            'compare' => 'LIKE'
        ),
        array(
            'key' => 'Start_Minute',
            'value' => '',
            'compare' => 'LIKE'
        )
    )
);

add_filter('posts_orderby','orderbyreplace');
$loop = new WP_Query( $args );
remove_filter('posts_orderby','orderbyreplace');

Viewing 1 replies (of 1 total)
  • The topic ‘How to Sorting / Order by multiple custom fields.’ is closed to new replies.