[wp-trac] [WordPress Trac] #27887: Add orderby meta_value_num option for WP_User_Query

[WordPress Trac]

#27887: Add orderby meta_value_num option for WP_User_Query
-----------------------------------------+------------------------------
 Reporter:  genkisan                     |       Owner:
     Type:  enhancement                  |      Status:  new
 Priority:  normal                       |   Milestone:  Awaiting Review
Component:  Users                        |     Version:  3.9
 Severity:  normal                       |  Resolution:
 Keywords:  has-patch reporter-feedback  |     Focuses:  template
-----------------------------------------+------------------------------

Comment (by genkisan):

 A workaround using the pre_user_query action (modified from
 [http://wordpress.stackexchange.com/a/98581/22451 wp stackexchange]).
 Would still be useful if WP_User_Query has the same meta_value_num option
 as WP_Query.

 {{{
 function my_pre_user_query($query) {
         $key = $query->get('meta_key');
         if ($key == 'your_key') {
                 global $wpdb;
                 $query->query_orderby = ' ORDER BY ' . $wpdb->usermeta  .
 '.meta_value+0 ' . $query->get('order');
         }
 }
 add_action('pre_user_query', 'my_pre_user_query');
 }}}

--
Ticket URL: <https://core.trac.wordpress.org/ticket/27887#comment:3>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform