A View to Search by Usernames or Email in Drupal 6/7
I'll fully admit Drupal has one crappy user administration interface. And, since I get quite a few of the "can you find info about this user?" requests, which take so little time I can't bill for them :), I've expanded on the Drupal Post installation support question:
Search for username in Users list?
https://www.drupal.org/node/744628
and created a custom view to help out my customers.
In the better late than never, I've finally gotten around to publishing it . . .
This is for Drupal 6 or Drupal 7. I like this better than the D7 /search/user , ...
Search-able on:
User Name
User Email
Shows:
Name
Edit link
Uid
Active
Roles
Last login
Last access
Created date
You will need to be logged in as either UID1 or an account that has 'administer users' permissions.
To import the view, copy everything below and paste that into your:
View >> Import >> "Paste view code here:"
D6: /admin/build/views/import
D7: /admin/structure/views/import
field. You man leave the "View name:" field blank or change it to whatever you so desire.
Unless you've edited it, the path will be {youdomain.name}/admin/usersearch .
Best,
Michael
Internet Design Alliance, owner
http://inet-design.com
PS: No, I don't know why "Created date" isn't sortable. I agree it should be, but I'm not going to go dig into why the views defaults aren't making it sortable while the other date fields are.
$view = new view(); $view->name = 'admin_user_search'; $view->description = 'Administrator User Search'; $view->tag = ''; $view->base_table = 'users'; $view->human_name = 'User Search for Administrators'; $view->core = 6; $view->api_version = '3.0'; $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */ /* Display: Defaults */ $handler = $view->new_display('default', 'Defaults', 'default'); $handler->display->display_options['use_more_always'] = FALSE; $handler->display->display_options['access']['type'] = 'perm'; $handler->display->display_options['access']['perm'] = 'administer users'; $handler->display->display_options['cache']['type'] = 'none'; $handler->display->display_options['query']['type'] = 'views_query'; $handler->display->display_options['exposed_form']['type'] = 'basic'; $handler->display->display_options['exposed_form']['options']['reset_button'] = TRUE; $handler->display->display_options['pager']['type'] = 'none'; $handler->display->display_options['style_plugin'] = 'table'; $handler->display->display_options['style_options']['grouping'] = ''; $handler->display->display_options['style_options']['columns'] = array( 'access' => 'access', 'login' => 'login', 'name' => 'name', 'uid' => 'uid', ); $handler->display->display_options['style_options']['default'] = 'name'; $handler->display->display_options['style_options']['info'] = array( 'access' => array( 'sortable' => 1, 'separator' => '', ), 'login' => array( 'sortable' => 1, 'separator' => '', ), 'name' => array( 'sortable' => 1, 'separator' => '', ), 'uid' => array( 'sortable' => 1, 'separator' => '', ), ); /* Field: User: Name */ $handler->display->display_options['fields']['name']['id'] = 'name'; $handler->display->display_options['fields']['name']['table'] = 'users'; $handler->display->display_options['fields']['name']['field'] = 'name'; /* Field: User: Edit link */ $handler->display->display_options['fields']['edit_node']['id'] = 'edit_node'; $handler->display->display_options['fields']['edit_node']['table'] = 'users'; $handler->display->display_options['fields']['edit_node']['field'] = 'edit_node'; /* Field: User: Uid */ $handler->display->display_options['fields']['uid']['id'] = 'uid'; $handler->display->display_options['fields']['uid']['table'] = 'users'; $handler->display->display_options['fields']['uid']['field'] = 'uid'; /* Field: User: Active */ $handler->display->display_options['fields']['status']['id'] = 'status'; $handler->display->display_options['fields']['status']['table'] = 'users'; $handler->display->display_options['fields']['status']['field'] = 'status'; $handler->display->display_options['fields']['status']['not'] = 0; /* Field: User: Roles */ $handler->display->display_options['fields']['rid']['id'] = 'rid'; $handler->display->display_options['fields']['rid']['table'] = 'users_roles'; $handler->display->display_options['fields']['rid']['field'] = 'rid'; /* Field: User: Last login */ $handler->display->display_options['fields']['login']['id'] = 'login'; $handler->display->display_options['fields']['login']['table'] = 'users'; $handler->display->display_options['fields']['login']['field'] = 'login'; $handler->display->display_options['fields']['login']['date_format'] = 'medium'; /* Field: User: Last access */ $handler->display->display_options['fields']['access']['id'] = 'access'; $handler->display->display_options['fields']['access']['table'] = 'users'; $handler->display->display_options['fields']['access']['field'] = 'access'; $handler->display->display_options['fields']['access']['date_format'] = 'medium'; /* Field: User: Created date */ $handler->display->display_options['fields']['created']['id'] = 'created'; $handler->display->display_options['fields']['created']['table'] = 'users'; $handler->display->display_options['fields']['created']['field'] = 'created'; $handler->display->display_options['fields']['created']['date_format'] = 'medium'; /* Filter criterion: User: Name (raw) */ $handler->display->display_options['filters']['name']['id'] = 'name'; $handler->display->display_options['filters']['name']['table'] = 'users'; $handler->display->display_options['filters']['name']['field'] = 'name'; $handler->display->display_options['filters']['name']['operator'] = 'contains'; $handler->display->display_options['filters']['name']['group'] = '0'; $handler->display->display_options['filters']['name']['exposed'] = TRUE; $handler->display->display_options['filters']['name']['expose']['operator_id'] = 'name_op'; $handler->display->display_options['filters']['name']['expose']['label'] = 'Part of a User\'s name'; $handler->display->display_options['filters']['name']['expose']['operator'] = 'name_op'; $handler->display->display_options['filters']['name']['expose']['identifier'] = 'name'; /* Filter criterion: User: E-mail */ $handler->display->display_options['filters']['mail']['id'] = 'mail'; $handler->display->display_options['filters']['mail']['table'] = 'users'; $handler->display->display_options['filters']['mail']['field'] = 'mail'; $handler->display->display_options['filters']['mail']['operator'] = 'contains'; $handler->display->display_options['filters']['mail']['group'] = '0'; $handler->display->display_options['filters']['mail']['exposed'] = TRUE; $handler->display->display_options['filters']['mail']['expose']['operator_id'] = 'mail_op'; $handler->display->display_options['filters']['mail']['expose']['label'] = 'Part of a User\'s E-mail'; $handler->display->display_options['filters']['mail']['expose']['operator'] = 'mail_op'; $handler->display->display_options['filters']['mail']['expose']['identifier'] = 'mail'; /* Filter criterion: User: The user ID */ $handler->display->display_options['filters']['uid_raw']['id'] = 'uid_raw'; $handler->display->display_options['filters']['uid_raw']['table'] = 'users'; $handler->display->display_options['filters']['uid_raw']['field'] = 'uid_raw'; $handler->display->display_options['filters']['uid_raw']['operator'] = '>='; $handler->display->display_options['filters']['uid_raw']['value']['value'] = '2'; /* Display: Page */ $handler = $view->new_display('page', 'Page', 'page_1'); $handler->display->display_options['path'] = 'admin/usersearch'; $translatables['admin_user_search'] = array( t('Defaults'), t('more'), t('Apply'), t('Reset'), t('Sort by'), t('Asc'), t('Desc'), t('Name'), t('Edit link'), t('Uid'), t('Active'), t('Roles'), t('Last login'), t('Last access'), t('Created date'), t('Part of a User\'s name'), t('Part of a User\'s E-mail'), t('Page'), );
Add new comment