ACF Ordering posts by number field treated like a string-CodePudding

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;

CodePudding user response：

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;

CodePudding user response：

    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;

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