Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
I'm using Views 6.x-2.16 and the Admin Views alpha. On the site, there are Profile fields such as First and Last Name that are required, but there are some old users with no Profile information. These users without Profile data do not show in results if Profile fields are in my modified users table. Below is my exported view:
$view = new view;
$view->name = 'admin_user_user';
$view->description = 'List, add, and edit users.';
$view->tag = 'admin';
$view->base_table = 'users';
$view->core = 0;
$view->api_version = '2';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('fields', array(
'name' => array(
'label' => 'Username',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'absolute' => 0,
'link_class' => '',
'alt' => '',
'rel' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'hide_alter_empty' => 1,
'link_to_user' => 1,
'overwrite_anonymous' => 0,
'anonymous_text' => '',
'exclude' => 0,
'id' => 'name',
'table' => 'users',
'field' => 'name',
'relationship' => 'none',
),
'value' => array(
'label' => 'First Name',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'absolute' => 0,
'link_class' => '',
'alt' => '',
'rel' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'hide_alter_empty' => 1,
'link_to_user' => 0,
'exclude' => 0,
'id' => 'value',
'table' => 'profile_values_profile_first_name',
'field' => 'value',
'relationship' => 'none',
),
'value_1' => array(
'label' => 'Last Name',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'absolute' => 0,
'link_class' => '',
'alt' => '',
'rel' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'hide_alter_empty' => 1,
'link_to_user' => 0,
'exclude' => 0,
'id' => 'value_1',
'table' => 'profile_values_profile_last_name',
'field' => 'value',
'relationship' => 'none',
),
'status' => array(
'label' => 'Active',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'strip_tags' => 0,
'html' => 0,
),
'type' => 'yes-no',
'not' => 0,
'exclude' => 0,
'id' => 'status',
'table' => 'users',
'field' => 'status',
'relationship' => 'none',
),
'rid' => array(
'label' => 'Roles',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'strip_tags' => 0,
'html' => 0,
),
'type' => 'ul',
'separator' => ', ',
'empty' => '',
'exclude' => 0,
'id' => 'rid',
'table' => 'users_roles',
'field' => 'rid',
'relationship' => 'none',
),
'created' => array(
'label' => 'Member for',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'strip_tags' => 0,
'html' => 0,
),
'date_format' => 'time ago',
'custom_date_format' => '',
'exclude' => 0,
'id' => 'created',
'table' => 'users',
'field' => 'created',
'relationship' => 'none',
),
'access' => array(
'label' => 'Last access',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'strip_tags' => 0,
'html' => 0,
),
'date_format' => 'time ago',
'custom_date_format' => '',
'exclude' => 0,
'id' => 'access',
'table' => 'users',
'field' => 'access',
'relationship' => 'none',
),
'edit_node' => array(
'label' => '',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'strip_tags' => 0,
'html' => 0,
),
'text' => '',
'exclude' => 0,
'id' => 'edit_node',
'table' => 'users',
'field' => 'edit_node',
'relationship' => 'none',
),
'delete_node' => array(
'label' => '',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'strip_tags' => 0,
'html' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'text' => '',
'exclude' => 0,
'id' => 'delete_node',
'table' => 'users',
'field' => 'delete_node',
'override' => array(
'button' => 'Override',
),
'relationship' => 'none',
),
));
$handler->override_option('sorts', array(
'created' => array(
'order' => 'DESC',
'granularity' => 'second',
'id' => 'created',
'table' => 'users',
'field' => 'created',
'relationship' => 'none',
),
));
$handler->override_option('filters', array(
'uid' => array(
'operator' => 'in',
'value' => '',
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'uid_op',
'identifier' => 'username',
'label' => 'Username',
'optional' => 1,
'remember' => 1,
'reduce' => 0,
),
'id' => 'uid',
'table' => 'users',
'field' => 'uid',
'relationship' => 'none',
),
'value' => array(
'operator' => 'contains',
'value' => '',
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'value_op',
'identifier' => 'firstname',
'label' => 'First Name',
'remember' => 0,
),
'case' => 0,
'id' => 'value',
'table' => 'profile_values_profile_first_name',
'field' => 'value',
'relationship' => 'none',
),
'value_1' => array(
'operator' => 'contains',
'value' => '',
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'value_1_op',
'identifier' => 'lastname',
'label' => 'Last Name',
'remember' => 0,
),
'case' => 0,
'id' => 'value_1',
'table' => 'profile_values_profile_last_name',
'field' => 'value',
'relationship' => 'none',
),
'status' => array(
'operator' => '=',
'value' => 'All',
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'operator' => '',
'identifier' => 'status',
'label' => 'Active',
'optional' => 1,
'remember' => 1,
),
'id' => 'status',
'table' => 'users',
'field' => 'status',
'relationship' => 'none',
),
'rid' => array(
'operator' => 'and',
'value' => array(),
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'rid_op',
'identifier' => 'rid',
'label' => 'Roles',
'optional' => 1,
'single' => 0,
'remember' => 1,
'reduce' => 0,
),
'id' => 'rid',
'table' => 'users_roles',
'field' => 'rid',
'relationship' => 'none',
'reduce_duplicates' => 0,
),
));
$handler->override_option('access', array(
'type' => 'perm',
'perm' => 'administer users',
));
$handler->override_option('cache', array(
'type' => 'none',
));
$handler->override_option('title', 'Users');
$handler->override_option('empty', '<p>There are no results that match your query.</p>');
$handler->override_option('empty_format', '1');
$handler->override_option('items_per_page', 50);
$handler->override_option('use_pager', '1');
$handler->override_option('pager_element', 20);
$handler->override_option('style_plugin', 'bulk');
$handler->override_option('style_options', array(
'grouping' => '',
'override' => 1,
'sticky' => 1,
'order' => 'desc',
'summary' => '',
'columns' => array(
'name' => 'name',
'value' => 'value',
'value_1' => 'value_1',
'status' => 'status',
'rid' => 'rid',
'created' => 'created',
'access' => 'access',
'edit_node' => 'edit_node',
'delete_node' => 'delete_node',
),
'info' => array(
'name' => array(
'sortable' => 1,
'separator' => '',
),
'value' => array(
'sortable' => 1,
'separator' => '',
),
'value_1' => array(
'sortable' => 1,
'separator' => '',
),
'status' => array(
'sortable' => 1,
'separator' => '',
),
'rid' => array(
'separator' => '',
),
'created' => array(
'sortable' => 1,
'separator' => '',
),
'access' => array(
'sortable' => 1,
'separator' => '',
),
'edit_node' => array(
'separator' => '',
),
'delete_node' => array(
'separator' => '',
),
),
'default' => 'created',
'execution_type' => '2',
'max_performance' => 0,
'display_type' => '0',
'hide_selector' => 0,
'preserve_selection' => 1,
'display_result' => 1,
'merge_single_action' => 0,
'operations' => array(
'user_block_ip_action' => array(
'selected' => 0,
'skip_confirmation' => 0,
'label' => '',
),
'user_block_user_action' => array(
'selected' => 0,
'skip_confirmation' => 0,
'label' => '',
),
'user_user_operations_block' => array(
'selected' => 1,
'skip_confirmation' => 0,
'label' => '',
),
'views_bulk_operations_delete_user_action' => array(
'selected' => 1,
'skip_confirmation' => 0,
'label' => '',
),
'system_message_action' => array(
'selected' => 0,
'skip_confirmation' => 0,
'label' => '',
),
'token_actions_message_action' => array(
'selected' => 0,
'skip_confirmation' => 0,
'label' => '',
),
'views_bulk_operations_action' => array(
'selected' => 0,
'skip_confirmation' => 0,
'label' => '',
),
'views_bulk_operations_script_action' => array(
'selected' => 0,
'skip_confirmation' => 0,
'label' => '',
),
'views_bulk_operations_profile_action' => array(
'selected' => 0,
'skip_confirmation' => 0,
'label' => '',
),
'views_bulk_operations_user_roles_action' => array(
'selected' => 1,
'skip_confirmation' => 0,
'label' => '',
),
'views_bulk_operations_argument_selector_action' => array(
'selected' => 0,
'skip_confirmation' => 0,
'label' => '',
),
'token_actions_goto_action' => array(
'selected' => 0,
'skip_confirmation' => 0,
'label' => '',
),
'system_goto_action' => array(
'selected' => 0,
'skip_confirmation' => 0,
'label' => '',
),
'system_send_email_action-8c5ace7a579c6b3b24e71ee88e42c51a' => array(
'selected' => 0,
'skip_confirmation' => 0,
'label' => '',
),
'system_send_email_action' => array(
'selected' => 1,
'skip_confirmation' => 0,
'label' => '',
),
'token_actions_send_email_action' => array(
'selected' => 0,
'skip_confirmation' => 0,
'label' => '',
),
'user_user_operations_unblock' => array(
'selected' => 1,
'skip_confirmation' => 0,
'label' => '',
),
'pathauto_user_update_alias_multiple-620e193b20ba9caa374fea9ca0ad38f0' => array(
'selected' => 0,
'skip_confirmation' => 0,
'label' => '',
),
),
));
$handler = $view->new_display('system', 'System', 'system_1');
$handler->override_option('pager_element', 0);
$handler->override_option('path', 'admin/user/user');
Comments
Comment #1
rajmataj CreditAttribution: rajmataj commentedI'm using Drupal 7, not 6 but this may help: In the View, is there a Relationship set up to look for profile fields? If so, if 'Require this relationship' is checked, uncheck that. You may see the full set of results you're expecting instead of seeing only those users whom have profile info.
Comment #2
dandaman CreditAttribution: dandaman commentedLooking at the view, there is no explicit relationships involved. The Profile fields are just implicitly related to the User, it seems. So maybe this is a bug in the core Profile module then?
Comment #3
damiankloip CreditAttribution: damiankloip commentedPossibly a views profile integration issue.
Comment #4
DamienMcKennaMoving this to the Views issue queue because it sounds like a bug in Views.
Comment #5
Chris Matthews CreditAttribution: Chris Matthews as a volunteer commentedThe Drupal 6 branch is no longer supported, please check with the D6LTS project if you need further support. For more information as to why this issue was closed, please see issue #3030347: Plan to clean process issue queue