Sorting Custom User Columns WordPress

Daniel Yoen answers:

try to use 'pre_get_posts' instead 'request'.

add_action( 'pre_get_posts', 'status_column_orderby' );

hope this help :-)

Kyle comments:

Thanks for the reply, no luck though

Daniel Yoen comments:

complete code :-)

add_action( 'pre_get_posts', 'event_column_orderby' );
function event_column_orderby($query)
{
$orderby = $query->get('orderby');

if('status' == $orderby)
{
$query->set('meta_key','status');
$query->set('orderby','meta_value');
}
}

hope this help :-)

Kyle comments:

Still no luck

asok answers:

I'm looking to see if there is a simpler/efficient way.

but isn't the column name user_status. Tried to edit your code to use 'user_status' as the column name, instead. See if it works.


function modify_user_table( $column ) {
$column['user_status'] = 'Status';
return $column;
}
add_filter( 'manage_users_columns', 'modify_user_table' );

function modify_user_table_row( $val, $column_name, $user_id ) {
$user = get_userdata( $user_id );
switch ($column_name) {
case 'user_status' :
$status = $user->user_status;
if ($status == 'Current'){
return '<div class="special2">'.$status.'</div>';
}else if ($status == 'Past Due'){
return '<div class="special1">'.$status.'</div>';
}else{ return '<div class="special">'.$status.'</div>'; }
break;
default:
}

switch ($column_name) {
case 'user_status' :
return $user->user_status;
break;
default:
}
return $return;
}
add_filter( 'manage_users_custom_column', 'modify_user_table_row', 10, 3 );

function status_column_sortable($columns) {
$custom = array(
'user_status' => 'user_status',
);
return wp_parse_args($custom, $columns);
}
add_filter( 'manage_users_sortable_columns', 'status_column_sortable' );

function status_column_orderby( $vars ) {
if ( isset( $vars['orderby'] ) && 'status' == $vars['orderby'] ) {
$vars = array_merge( $vars, array(
'meta_key' => 'user_status',
'orderby' => 'meta_value'
) );
}
return $vars;
}
add_filter( 'request', 'status_column_orderby' );


Kyle comments:

Interesting... technically this worked, but it does not display users with empty meta_values for the column

Arnav Joy answers:

try this

function modify_user_table( $column ) {

$column['status'] = 'status';

return $column;

}

add_filter( 'manage_users_columns', 'modify_user_table' );



function modify_user_table_row( $val, $column_name, $user_id ) {

$user = get_userdata( $user_id );

switch ($column_name) {

case 'status' :

$status = $user->status;

if ($status == 'Current'){

return '<div class="special2">'.$status.'</div>';

}else if ($status == 'Past Due'){

return '<div class="special1">'.$status.'</div>';

}else{ return '<div class="special">'.$status.'</div>'; }

break;

default:

}

switch ($column_name) {

case 'status' :

return $user->status;

break;

default:

}

return $return;

}

add_filter( 'manage_users_custom_column', 'modify_user_table_row', 10, 3 );



function status_column_sortable($columns) {

$custom = array(

'status' => 'status',

);

return wp_parse_args($custom, $columns);

}

add_filter( 'manage_users_sortable_columns', 'status_column_sortable' );



function status_column_orderby( $vars ) {

if ( isset( $vars['orderby'] ) && 'status' == $vars['orderby'] ) {

$vars = array_merge( $vars, array(

'meta_key' => 'status',

'orderby' => 'meta_value'

) );

}

return $vars;

}

add_filter( 'request', 'status_column_orderby' );

Kyle comments:

Can you please specify what changes you made

Arnav Joy comments:

i changed this line


$column['status'] = 'Status';

to

$column['status'] = 'status';

Kyle comments:

Oh okay, no luck there

Thanks for the reply btw

Dbranes answers:

Hi, I just wanted to join the sorting club here ;-)

Here is another way to sort the custom column:

[[LINK href="http://j3webworks.com/blog/wordpress-add-and-sort-custom-column-in-users-admin-page"]]http://j3webworks.com/blog/wordpress-add-and-sort-custom-column-in-users-admin-page[[/LINK]]

By using the above info, with some modifications, I can get your code to work, if I add this part:

add_action('pre_user_query', 'status_order_in_user_query');
function status_order_in_user_query($query){
// print_r($query); // for debugging
if('status'==$query->query_vars['orderby']) {
$query->query_orderby = " ORDER BY user_status ".($query->query_vars["order"] == "ASC" ? "asc " : "desc ");//set sort order
}
}


I just order by the <strong>user_status</strong> field in the <strong>wp_users</strong> table (not doing any meta_value ordering)

Hope this helps ;-)

<strong>PS:</strong> I just had to replace <strong>$user->status</strong> with <strong>$user->user_status,</strong>, in your code, to get the status values on my single WP install.

Kyle comments:

Thanks for the reply

No accurate result though

Dbranes comments:

ok, looks like your setup is different ;-)

ps: just curious, did you add a new <strong>status</strong> column in the wp_users table?

$user = get_userdata( $user_id );
print_r($user);


does not give me any <strong>status</strong> value.

Kyle comments:

Yes I did, should have said that explicitly

Did so with this: http://wordpress.org/extend/plugins/user-meta-manager/

Pretty well made plugin, nice ajax actions

Dbranes comments:

ok, that explains it ;-)
'
so you actually need user meta sorting instead of my user_status field sortering

You can check out the link I provided above, it has the original code used by myself and @Navjot.

... thanks for the info