The exposed filter is getting displayed 3 times instead of the single time I would expect, see the attached image.
View Export:
<?php
$view = new view;
$view->name = 'emerg_contact';
$view->description = 'A list of all contacts, by letter.';
$view->tag = 'default';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$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(
'field_name_first_value' => array(
'label' => 'First Name',
'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,
),
'link_to_node' => 0,
'label_type' => 'widget',
'format' => 'plain',
'multiple' => array(
'group' => TRUE,
'multiple_number' => '',
'multiple_from' => '',
'multiple_reversed' => FALSE,
),
'exclude' => 0,
'id' => 'field_name_first_value',
'table' => 'node_data_field_name_first',
'field' => 'field_name_first_value',
'relationship' => 'none',
),
'field_name_last_value' => array(
'label' => 'Last Name',
'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,
),
'link_to_node' => 0,
'label_type' => 'widget',
'format' => 'plain',
'multiple' => array(
'group' => TRUE,
'multiple_number' => '',
'multiple_from' => '',
'multiple_reversed' => FALSE,
),
'exclude' => 0,
'id' => 'field_name_last_value',
'table' => 'node_data_field_name_last',
'field' => 'field_name_last_value',
'relationship' => 'none',
),
'field_job_title_value' => array(
'label' => 'Position Title',
'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,
),
'link_to_node' => 0,
'label_type' => 'widget',
'format' => 'trimmed',
'multiple' => array(
'group' => TRUE,
'multiple_number' => '',
'multiple_from' => '',
'multiple_reversed' => FALSE,
),
'exclude' => 0,
'id' => 'field_job_title_value',
'table' => 'node_data_field_job_title',
'field' => 'field_job_title_value',
'relationship' => 'none',
),
'field_campus_value' => array(
'label' => 'Campus',
'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,
),
'link_to_node' => 0,
'label_type' => 'widget',
'format' => 'default',
'multiple' => array(
'group' => TRUE,
'multiple_number' => '',
'multiple_from' => '',
'multiple_reversed' => FALSE,
),
'exclude' => 0,
'id' => 'field_campus_value',
'table' => 'node_data_field_campus',
'field' => 'field_campus_value',
'relationship' => 'none',
),
'field_extension_value' => array(
'label' => 'Extension',
'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,
),
'link_to_node' => 0,
'label_type' => 'widget',
'format' => 'default',
'multiple' => array(
'group' => TRUE,
'multiple_number' => '',
'multiple_from' => '',
'multiple_reversed' => FALSE,
),
'exclude' => 0,
'id' => 'field_extension_value',
'table' => 'node_data_field_extension',
'field' => 'field_extension_value',
'relationship' => 'none',
),
'tid' => array(
'label' => 'Buildings',
'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' => 'separator',
'separator' => ', ',
'empty' => '',
'link_to_taxonomy' => 0,
'limit' => 1,
'vids' => array(
'2' => 2,
'3' => 0,
'1' => 0,
'5' => 0,
'6' => 0,
'4' => 0,
),
'exclude' => 0,
'id' => 'tid',
'table' => 'term_node',
'field' => 'tid',
'relationship' => 'none',
),
'view_node' => array(
'label' => 'more',
'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' => 'view_node',
'table' => 'node',
'field' => 'view_node',
'relationship' => 'none',
),
));
$handler->override_option('arguments', array(
'field_name_last_value' => array(
'default_action' => 'default',
'style_plugin' => 'default_summary',
'style_options' => array(),
'wildcard' => 'all',
'wildcard_substitution' => 'All',
'title' => '',
'breadcrumb' => '',
'default_argument_type' => 'fixed',
'default_argument' => '',
'validate_type' => 'none',
'validate_fail' => 'not found',
'glossary' => 1,
'limit' => '1',
'case' => 'upper',
'path_case' => 'lower',
'transform_dash' => 0,
'id' => 'field_name_last_value',
'table' => 'node_data_field_name_last',
'field' => 'field_name_last_value',
'validate_user_argument_type' => 'uid',
'validate_user_roles' => array(
'2' => 0,
'4' => 0,
'6' => 0,
'3' => 0,
'9' => 0,
'5' => 0,
'8' => 0,
'10' => 0,
'7' => 0,
),
'relationship' => 'none',
'default_options_div_prefix' => '',
'default_argument_user' => 0,
'default_argument_fixed' => 'a',
'default_argument_php' => '',
'validate_argument_node_type' => array(
'book' => 0,
'emergency_contact' => 0,
'news' => 0,
'page' => 0,
'procedure' => 0,
),
'validate_argument_node_access' => 0,
'validate_argument_nid_type' => 'nid',
'validate_argument_vocabulary' => array(
'3' => 0,
'1' => 0,
'5' => 0,
'6' => 0,
'4' => 0,
'2' => 0,
),
'validate_argument_type' => 'tid',
'validate_argument_transform' => 0,
'validate_user_restrict_roles' => 0,
'validate_argument_php' => '',
),
));
$handler->override_option('filters', array(
'type' => array(
'operator' => 'in',
'value' => array(
'emergency_contact' => 'emergency_contact',
),
'group' => '0',
'exposed' => FALSE,
'expose' => array(
'operator' => FALSE,
'label' => '',
),
'id' => 'type',
'table' => 'node',
'field' => 'type',
'relationship' => 'none',
),
'status_extra' => array(
'id' => 'status_extra',
'table' => 'node',
'field' => 'status_extra',
),
));
$handler->override_option('access', array(
'type' => 'none',
'role' => array(),
'perm' => '',
));
$handler->override_option('cache', array(
'type' => 'none',
));
$handler->override_option('title', 'Emergency Contacts');
$handler->override_option('use_ajax', '1');
$handler->override_option('items_per_page', 36);
$handler->override_option('use_pager', '1');
$handler->override_option('style_plugin', 'table');
$handler->override_option('style_options', array(
'grouping' => '',
'override' => 1,
'sticky' => 1,
'order' => 'asc',
'columns' => array(
'field_name_first_value' => 'field_name_first_value',
'field_name_last_value' => 'field_name_last_value',
'field_job_title_value' => 'field_job_title_value',
'field_campus_value' => 'field_campus_value',
'field_extension_value' => 'field_extension_value',
'tid' => 'tid',
'view_node' => 'view_node',
),
'info' => array(
'field_name_first_value' => array(
'sortable' => 1,
'separator' => '',
),
'field_name_last_value' => array(
'sortable' => 1,
'separator' => '',
),
'field_job_title_value' => array(
'sortable' => 0,
'separator' => '',
),
'field_campus_value' => array(
'sortable' => 1,
'separator' => '',
),
'field_extension_value' => array(
'sortable' => 0,
'separator' => '',
),
'tid' => array(
'separator' => '',
),
'view_node' => array(
'separator' => '',
),
),
'default' => 'field_name_last_value',
));
$handler = $view->new_display('page', 'Page', 'page');
$handler->override_option('filters', array(
'type' => array(
'operator' => 'in',
'value' => array(
'emergency_contact' => 'emergency_contact',
),
'group' => '0',
'exposed' => FALSE,
'expose' => array(
'operator' => FALSE,
'label' => '',
),
'id' => 'type',
'table' => 'node',
'field' => 'type',
'relationship' => 'none',
),
'status_extra' => array(
'id' => 'status_extra',
'table' => 'node',
'field' => 'status_extra',
),
'tid' => array(
'operator' => 'or',
'value' => '',
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'tid_op',
'identifier' => 'tid',
'label' => 'Building',
'optional' => 1,
'single' => 1,
'remember' => 0,
),
'type' => 'textfield',
'limit' => TRUE,
'vid' => '2',
'id' => 'tid',
'table' => 'term_node',
'field' => 'tid',
'hierarchy' => 0,
'override' => array(
'button' => 'Use default',
),
'relationship' => 'none',
'reduce_duplicates' => 0,
),
));
$handler->override_option('path', 'contacts');
$handler->override_option('menu', array(
'type' => 'normal',
'title' => 'Emergency Contacts',
'description' => '',
'weight' => '0',
'name' => 'navigation',
));
$handler->override_option('tab_options', array(
'type' => 'none',
'title' => '',
'description' => '',
'weight' => 0,
));
$handler = $view->new_display('attachment', 'Attachment', 'attachment');
$handler->override_option('arguments', array(
'field_name_last_value' => array(
'default_action' => 'summary asc',
'style_plugin' => 'unformatted_summary',
'style_options' => array(
'count' => 0,
'override' => 1,
'items_per_page' => '25',
'inline' => 1,
'separator' => ' | ',
),
'wildcard' => 'all',
'wildcard_substitution' => 'All',
'title' => '',
'breadcrumb' => '',
'default_argument_type' => 'fixed',
'default_argument' => '',
'validate_type' => 'none',
'validate_fail' => 'not found',
'glossary' => 1,
'limit' => '1',
'case' => 'upper',
'path_case' => 'lower',
'transform_dash' => 0,
'id' => 'field_name_last_value',
'table' => 'node_data_field_name_last',
'field' => 'field_name_last_value',
'validate_user_argument_type' => 'uid',
'validate_user_roles' => array(
'2' => 0,
'4' => 0,
'6' => 0,
'3' => 0,
'9' => 0,
'5' => 0,
'8' => 0,
'10' => 0,
'7' => 0,
),
'override' => array(
'button' => 'Use default',
),
'relationship' => 'none',
'default_options_div_prefix' => '',
'default_argument_user' => 0,
'default_argument_fixed' => '',
'default_argument_php' => '',
'validate_argument_node_type' => array(
'book' => 0,
'emergency_contact' => 0,
'news' => 0,
'page' => 0,
'procedure' => 0,
),
'validate_argument_node_access' => 0,
'validate_argument_nid_type' => 'nid',
'validate_argument_vocabulary' => array(
'3' => 0,
'1' => 0,
'5' => 0,
'6' => 0,
'4' => 0,
'2' => 0,
),
'validate_argument_type' => 'tid',
'validate_argument_transform' => 0,
'validate_user_restrict_roles' => 0,
'validate_argument_php' => '',
),
));
$handler->override_option('attachment_position', 'both');
$handler->override_option('inherit_arguments', 0);
$handler->override_option('inherit_exposed_filters', FALSE);
$handler->override_option('displays', array(
'default' => 'default',
'page' => 'page',
));
?>
Query:
SELECT node.nid AS nid,
node_data_field_name_last.field_name_first_value AS node_data_field_name_last_field_name_first_value,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_name_last.field_name_last_value AS node_data_field_name_last_field_name_last_value,
node_data_field_name_last.field_job_title_value AS node_data_field_name_last_field_job_title_value,
node_data_field_name_last.field_campus_value AS node_data_field_name_last_field_campus_value,
node_data_field_extension.field_extension_value AS node_data_field_extension_field_extension_value
FROM node node
LEFT JOIN content_type_emergency_contact node_data_field_name_last ON node.vid = node_data_field_name_last.vid
LEFT JOIN content_field_extension node_data_field_extension ON node.vid = node_data_field_extension.vid
WHERE (node.type in ('emergency_contact')) AND (node.status <> 0 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (SUBSTR(node_data_field_name_last.field_name_last_value, 1, 1) = 'a')
ORDER BY node_data_field_name_last_field_name_last_value ASC
| Comment | File | Size | Author |
|---|---|---|---|
| view-exposed filter issue (glossary).png | 16.64 KB | realityloop |
Comments
Comment #1
realityloop commentedThe same issue occurs on 6.x.2.x version of views too..
Comment #2
realityloop commentedUpdated to include inherit exposed filters and flushed all caches, but it is still displaying the exposed filter 3 times.
Comment #3
zhangx1a0 commentedsubscribe.
I have the same problem, the exposed filter displays twice here... strange
Comment #4
merlinofchaos commentedhttp://drupal.org/node/535206#comment-2277812