add_filter( 'manage_users_columns', function( $column ) {
$column['billing_phone'] = 'Phone number';
return $column;
} );
add_filter( 'manage_users_custom_column', function( $val, $column_name, $user_id ) {
switch( $column_name ) {
case 'billing_phone':
return get_user_meta( $user_id, 'billing_phone', true );
default:
}
return $val;
}, 10, 3 );
add_action( 'pre_user_query', function( $query ) {
// Users Page Only
global $pagenow;
if( $pagenow != 'users.php' ) {
return;
}
// Search Only
if( empty( $query->query_vars['search'] ) ) {
return;
}
// Left Join Usermeta
global $wpdb;
$query->query_from .= sprintf(
"
LEFT JOIN %s umeta_phone
ON umeta_phone.user_id = %s.ID
AND umeta_phone.meta_key = 'billing_phone'
",
$wpdb->usermeta, $wpdb->users
);
} );
// Add Usermeta To Search Columns
add_filter( 'user_search_columns', function( $search_columns, $search, $query ) {
$search_columns[] = 'umeta_phone.meta_value';
return $search_columns;
}, 10, 3 );
Admin Users panel add custom column and expand search to include it
Adds the column Billing Phone to the administrative Users list screen and expands search fields to include this in search results.
How to use
PHP Code Snippets
- Log into a staging, development, or locally hosted clone of your site
- Install and activate Code Snippets
- WP Admin > Snippets > Add New
- Copy and paste the code from the Description tab above
- Check to ensure formatting came over properly and no syntax errors show up in the editor
- Customize the code as desired
- Add a meaningful title
- Select whether to run on front-end or back-end (or both)
- Click “Save and Activate”
- Test your site to ensure it works
- Disable if any problems, or recover
- Repeat for live environment
License
All code snippets are licensed GPLv2 (or later) matching WordPress licensing.
Disclaimer of warranty:
Except when otherwise stated in writing the copyright holders and/or other parties provide the program as-is without warranty of any kind, either expressed or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose.
Support
- Describe the issue and what you’ve observed.
- Describe your expected outcome(s).
- List steps to reproduce the issue.
- Optionally provide screen-shot or video URLs.
