WP Query Order By Issue

• bcorchiolo

• November 15, 2019 at 9:08 am

I have a site with properties listed. First I’m sorting them by where they are located, then I want to order them by a ACF I created named the_order. I can’t quite figure out how to make it work.

All help is appreciated

$args = array(
‘post_type’ => ‘Property’,
‘meta_key’ => ‘the_borough’,
‘meta_value’ => $value[0],
‘orderby’ => ‘the_order’,
‘order’ => ‘DESC’
);

$the_query = new WP_Query( $args );
if ( $the_query->have_posts() ) : while ( $the_query->have_posts() ) : $the_query->the_post();

• benoldenburg

• November 18, 2019 at 12:39 pm

I was working through a similar issue based on the advice from this post and something like this example may work for you. In my case, it was a true/false field then a custom date.

$args = array(
    'post_type' => 'Property', // post type 
    'meta_query' => array(
        borough_clause => array(
            'key' => 'the_borough', 
        ),
        order_clause => array(
            'key' => 'the_order',
        ),
    ),
    'orderby' => array(
        'borough_clause' => 'ASC', // assuming borough alphabetical
        'order_clause' => 'ASC' // assuming custom order is 1 2 3 etc
    ),
    'posts_per_page'   => -1, // inlcude if you want all posts
));

• bcorchiolo

• November 18, 2019 at 1:11 pm

Thanks so much. I ended up using the export function right from the WP admin and that worked.