Display sortable User meta column in admin panel user’s page

I have defined login levels for users registered on my site as Level 1 and Level 2. I have added a column for same in admin panel users page (users.php), I’m trying to add sorting option but on click for sorting not working. The meta key is level. Here’s what I tried.

add_filter( 'manage_users_columns', 'myplugin_manage_users_columns');
function myplugin_manage_users_columns( $columns )
{
    $columns['login_level'] = 'Login Level';
    return $columns;
}

add_filter('manage_users_custom_column',  'myplugin_manage_users_custom_column', 10, 3);
function myplugin_manage_users_custom_column( $value, $column_name, $user_id )
{
    $user = get_userdata( $user_id );

    if ('login_level' == $column_name){
        $lLevel =  get_user_meta( $user_id, 'level', true );
        $value = $lLevel;
        return $value;
    }
}


//make the new column sortable
function user_sortable_columns( $columns ) {
$columns['login_level'] = 'login_level';
return $columns;
}
add_filter( 'manage_users_sortable_columns', 'user_sortable_columns' );

//set instructions on how to sort the new column

function my_user_query($userquery){
if('login_level'==$userquery->query_vars['orderby']) {
global $wpdb;
$userquery->query_from .= " LEFT OUTER JOIN $wpdb->usermeta AS alias ON ($wpdb->users.ID = alias.user_id) ";//note use of alias
$userquery->query_where .= " AND alias.meta_key = 'level' ";//which meta are we sorting with?
$userquery->query_orderby = " ORDER BY alias.meta_value ".($userquery->query_vars["title"] == "ASC" ? "asc " : "desc ");//set sort order
}
}

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

I replaced

//make the new column sortable
function user_sortable_columns( $columns ) {
  $columns['login_level'] = 'login_level';
  return $columns;
}
add_filter( 'manage_users_sortable_columns', 'user_sortable_columns' );
    
//set instructions on how to sort the new column
    

function my_user_query($userquery){
  if('login_level' == $userquery->query_vars['orderby']) {
    global $wpdb;
    $userquery->query_from .= " LEFT OUTER JOIN $wpdb->usermeta AS alias ON 
    ($wpdb->users.ID = alias.user_id) ";//note use of alias
    $userquery->query_where .= " AND alias.meta_key = 'login_level' ";//which meta are we sorting with?
    $userquery->query_orderby = " ORDER BY alias.meta_value ".($userquery->query_vars["title"] == "ASC" ? "asc " : "desc ");//set sort order
  }
}

with

//make the new column sortable
function prefix_sortable_columns( $columns ) {
  $columns['login_level'] = 'login_level';
  return $columns;
}
add_filter( 'manage_users_sortable_columns', 'prefix_sortable_columns' );


function prefix_sort_by_level( $query ) {
  if ( 'login_level' == $query->get( 'orderby' ) ) {
    $query->set( 'orderby', 'meta_value' );
    $query->set( 'meta_key', 'level' );
  }
}
add_action( 'pre_get_users', 'prefix_sort_by_level' );

And it’s done.

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0