How to make a custom column on the Users admin screen sortable?

Question

How to make a custom column on the Users admin screen sortable?

Jordan Rogers

2018年8月14日 17:01

I am in the process of adding an additional column to the Users admin screen to display the company for each user. I have been successful in getting this column to show in the table, but I am really struggling with making it sortable alphabetically.

The column header does seem to be activated as sortable, but if i click it to reorganise the list order, the table actually rearranges alphabetically based on the username as opposed to the company.

I have spent alot of time on the web looking for and adapting other solutions, but still no luck. I have seen plenty of examples of making custom columns sortable for post type admins screens but not the user admin screen.

Below is the code I am currently using to generate a "Company" column on the users admin screen and it is pulling in the author meta data "company".

//MAKE THE COLUMN SORTABLE

function user_sortable_columns( $columns ) {
    $columns['company'] = 'Company';
    return $columns;
}

add_filter( 'manage_users_sortable_columns', 'user_sortable_columns' );

add_action( "pre_get_users", function ( $WP_User_Query ) {

if ( isset( $WP_User_Query-query_vars["orderby"] )
     ( "company" === $WP_User_Query-query_vars["orderby"] )
) {
    $WP_User_Query-query_vars["meta_key"] = "company_name";
    $WP_User_Query-query_vars["orderby"] = "meta_value";
}

}, 10, 1 );

Topic screen-columns user-meta Wordpress

Category Web

ban-geoengineering · Accepted Answer · 2018年2月21日 19:38

This is my code which adds a sortable custom column (called Vendor ID) to the users table:

function fc_new_modify_user_table( $column ) {
    $column['vendor_id'] = 'Vendor ID';
    return $column;
}
add_filter( 'manage_users_columns', 'fc_new_modify_user_table' );

function fc_new_modify_user_table_row( $val, $column_name, $user_id ) {
    switch ($column_name) {
        case 'vendor_id' :
            return get_the_author_meta( 'vendor_id', $user_id );
        default:
    }
    return $val;
}
add_filter( 'manage_users_custom_column', 'fc_new_modify_user_table_row', 10, 3 );

function fc_my_sortable_cake_column( $columns ) {
    $columns['vendor_id'] = 'Vendor ID';

    //To make a column 'un-sortable' remove it from the array unset($columns['date']);

    return $columns;
}
add_filter( 'manage_users_sortable_columns', 'fc_my_sortable_cake_column' );

Simple and works fine for me.

mmm · Accepted Answer · 2016年8月3日 12:46

the action request works with post. for user it's pre_get_users :

add_action("pre_get_users", function ($WP_User_Query) {

    if (    isset($WP_User_Query->query_vars["orderby"])
        &&  ("company" === $WP_User_Query->query_vars["orderby"])
    ) {
        $WP_User_Query->query_vars["meta_key"] = "company_name";
        $WP_User_Query->query_vars["orderby"] = "meta_value";
    }

}, 10, 1);

How to make a custom column on the Users admin screen sortable?

About