Question 30694 in Wordpress Question posted in
The official Wordpress documentation can be found here.

ACF Ordering posts by number field treated like a string – WordPress

Ordering posts by number field treated like a string. I have a custom number field (by ACF). and set my several posts as like 99 98 97 to show first in homepage. but the ordering after 10 is wrong. After searching i need to use orderby meta_value_num instead of meta_value. I have multiple meta values in the array. How to apply?

shown as: 99 98 97 …… 92 91 90 9 89 88 …. 80 8 79 78…

other example: 9 82 6 4 16 15 14

desired: 82 16 15 14 9 6 4

How can i fix this?

    if( isset($query->query_vars['post_type']) && $query->query_vars['post_type'] == 'post' ) {
    
    $query->set('meta_query', array(
            'myordernumber' => array(
                'key' => 'myordernumber',
            )                    
        ));
        
        $query->set('orderby',array(
            'myordernumber' => 'DESC', 
            'date' => 'DESC'
        ));     

    
    
}


// return
return $query;
Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0 
        if( isset($query->query_vars['post_type']) && $query->query_vars['post_type'] == 'post' ) {
    
    $query->set('meta_query', array('myordernumber' => array(                 
                'key' => 'myordernumber',)));
        
   $query->set('orderby', array('meta_value_num' => 'DESC', 
                                'date' => 'DESC')  );        
   }
   return $query;

    Related: https://make.wordpress.org/core/2014/08/29/a-more-powerful-order-by-in-wordpress-4-0/

    https://developer.wordpress.org/reference/hooks/pre_get_posts/


  2. 0

    You should use meta_value_num instead of myordernumber

    Look at this:
    https://wordpress.stackexchange.com/questions/30241/wp-query-order-results-by-meta-value
    https://developer.wordpress.org/reference/classes/wp_query/#order-orderby-parameters

    Think should be:

    $args = array(
    
    'post_type'=>'post',
    'meta_key' => 'myordernumber',
    'orderby' => array(
            'meta_value_num' => 'DESC', 
            'date' => 'DESC')  
   );
$query = new WP_Query( $args );

    Alt.

    if( isset($query->query_vars['post_type']) && $query->query_vars['post_type'] == 'post' ) {
    
    $query->set('meta_key', 'myordernumber');
        
   $query->set('orderby', array('meta_value_num' => 'DESC', 
                                'date' => 'DESC')  );        
    
}
return $query;
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search