Closed (fixed)
Project:
Views (for Drupal 7)
Version:
6.x-3.0
Component:
exposed filters
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
10 Oct 2012 at 22:35 UTC
Updated:
31 Oct 2012 at 16:01 UTC
Issue:
Please excuse if this has been addressed before. It seems like an issue which *must* have been previously addressed, although my quick search did not find this to be a duplicate issue.
I have a View which exposes a filter that allows admins to find nodes which are in select workflow states. The View is functioning properly and returning the correct results. However, it is displaying the (unselectable) Workflow names in the exposed filter drop-down.
Is there a way to expose the workflow state (in my case "QA Approval" and "Marketing Approval") without displaying the names of the Workflows ("Devices Workflow" and "Publish Workflow")?
Thank you!
View:
$view = new view;
$view->name = 'devices_workflow';
$view->description = 'A list of pending devices, most useful for determining which workflow state they are in';
$view->tag = 'custom';
$view->base_table = 'node';
$view->human_name = 'Devices - Workflow';
$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['access']['type'] = 'none';
$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['pager']['type'] = 'full';
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['columns'] = array(
'title' => 'title',
'changed' => 'changed',
'sid' => 'sid',
'state' => 'state',
'stamp' => 'stamp',
);
$handler->display->display_options['style_options']['default'] = '-1';
$handler->display->display_options['style_options']['info'] = array(
'title' => array(
'sortable' => 0,
'default_sort_order' => 'asc',
'align' => '',
'separator' => '',
),
'changed' => array(
'sortable' => 0,
'default_sort_order' => 'asc',
'align' => '',
'separator' => '',
),
'sid' => array(
'sortable' => 0,
'default_sort_order' => 'asc',
'align' => '',
'separator' => '',
),
'state' => array(
'sortable' => 0,
'default_sort_order' => 'asc',
'align' => '',
'separator' => '',
),
'stamp' => array(
'sortable' => 0,
'default_sort_order' => 'asc',
'align' => '',
'separator' => '',
),
);
$handler->display->display_options['style_options']['override'] = 1;
$handler->display->display_options['style_options']['sticky'] = 0;
$handler->display->display_options['style_options']['empty_table'] = 0;
/* Field: Node: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['title']['alter']['external'] = 0;
$handler->display->display_options['fields']['title']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['title']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['element_label_colon'] = 1;
$handler->display->display_options['fields']['title']['element_default_classes'] = 1;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Field: Workflow: Current state name */
$handler->display->display_options['fields']['state']['id'] = 'state';
$handler->display->display_options['fields']['state']['table'] = 'workflow_states';
$handler->display->display_options['fields']['state']['field'] = 'state';
$handler->display->display_options['fields']['state']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['state']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['state']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['state']['alter']['external'] = 0;
$handler->display->display_options['fields']['state']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['state']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['state']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['state']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['state']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['state']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['state']['alter']['trim'] = 0;
$handler->display->display_options['fields']['state']['alter']['html'] = 0;
$handler->display->display_options['fields']['state']['element_label_colon'] = 1;
$handler->display->display_options['fields']['state']['element_default_classes'] = 1;
$handler->display->display_options['fields']['state']['hide_empty'] = 0;
$handler->display->display_options['fields']['state']['empty_zero'] = 0;
$handler->display->display_options['fields']['state']['hide_alter_empty'] = 1;
/* Field: Workflow: Current time */
$handler->display->display_options['fields']['stamp']['id'] = 'stamp';
$handler->display->display_options['fields']['stamp']['table'] = 'workflow_node';
$handler->display->display_options['fields']['stamp']['field'] = 'stamp';
$handler->display->display_options['fields']['stamp']['label'] = 'Last state change';
$handler->display->display_options['fields']['stamp']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['stamp']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['stamp']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['stamp']['alter']['external'] = 0;
$handler->display->display_options['fields']['stamp']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['stamp']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['stamp']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['stamp']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['stamp']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['stamp']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['stamp']['alter']['trim'] = 0;
$handler->display->display_options['fields']['stamp']['alter']['html'] = 0;
$handler->display->display_options['fields']['stamp']['element_label_colon'] = 1;
$handler->display->display_options['fields']['stamp']['element_default_classes'] = 1;
$handler->display->display_options['fields']['stamp']['hide_empty'] = 0;
$handler->display->display_options['fields']['stamp']['empty_zero'] = 0;
$handler->display->display_options['fields']['stamp']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['stamp']['date_format'] = 'time ago';
/* Field: Node: Edit link */
$handler->display->display_options['fields']['edit_node']['id'] = 'edit_node';
$handler->display->display_options['fields']['edit_node']['table'] = 'node';
$handler->display->display_options['fields']['edit_node']['field'] = 'edit_node';
$handler->display->display_options['fields']['edit_node']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['external'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['edit_node']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['edit_node']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['trim'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['html'] = 0;
$handler->display->display_options['fields']['edit_node']['element_label_colon'] = 1;
$handler->display->display_options['fields']['edit_node']['element_default_classes'] = 1;
$handler->display->display_options['fields']['edit_node']['hide_empty'] = 0;
$handler->display->display_options['fields']['edit_node']['empty_zero'] = 0;
$handler->display->display_options['fields']['edit_node']['hide_alter_empty'] = 1;
/* Filter: Node: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
'devices' => 'devices',
);
/* Filter: Workflow: Current state */
$handler->display->display_options['filters']['sid']['id'] = 'sid';
$handler->display->display_options['filters']['sid']['table'] = 'workflow_node';
$handler->display->display_options['filters']['sid']['field'] = 'sid';
$handler->display->display_options['filters']['sid']['value'] = array(
7 => '7',
8 => '8',
);
$handler->display->display_options['filters']['sid']['exposed'] = TRUE;
$handler->display->display_options['filters']['sid']['expose']['operator'] = 'sid_op';
$handler->display->display_options['filters']['sid']['expose']['limit_operators'] = array();
$handler->display->display_options['filters']['sid']['expose']['label'] = 'Workflow: Current state';
$handler->display->display_options['filters']['sid']['expose']['identifier'] = 'sid';
$handler->display->display_options['filters']['sid']['expose']['reduce'] = 1;
/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->display->display_options['defaults']['filters'] = FALSE;
/* Filter: Node: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
'devices' => 'devices',
);
/* Filter: Workflow: Current state */
$handler->display->display_options['filters']['sid']['id'] = 'sid';
$handler->display->display_options['filters']['sid']['table'] = 'workflow_node';
$handler->display->display_options['filters']['sid']['field'] = 'sid';
$handler->display->display_options['filters']['sid']['value'] = array(
7 => '7',
8 => '8',
);
$handler->display->display_options['filters']['sid']['exposed'] = TRUE;
$handler->display->display_options['filters']['sid']['expose']['operator'] = 'sid_op';
$handler->display->display_options['filters']['sid']['expose']['limit_operators'] = array();
$handler->display->display_options['filters']['sid']['expose']['label'] = 'Workflow: Current state';
$handler->display->display_options['filters']['sid']['expose']['identifier'] = 'sid';
$handler->display->display_options['filters']['sid']['expose']['optional'] = 0;
$handler->display->display_options['filters']['sid']['expose']['reduce'] = 1;
$handler->display->display_options['path'] = 'devices/workflow';
Query:
SELECT node.title AS node_title,
node.nid AS nid,
workflow_states.state AS workflow_states_state,
workflow_node.stamp AS workflow_node_stamp,
node.uid AS node_uid,
node.type AS node_type,
node_revisions.format AS node_revisions_format
FROM node node
LEFT JOIN workflow_node workflow_node ON node.nid = workflow_node.nid
LEFT JOIN workflow_states workflow_states ON workflow_node.sid = workflow_states.sid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
WHERE (node.type in ('devices')) AND (workflow_node.sid = 7)
| Comment | File | Size | Author |
|---|---|---|---|
| exposed_filter_user.png | 46.35 KB | nonprofit | |
| exposed_filter_admin.png | 88.1 KB | nonprofit |
Comments
Comment #1
nonprofit commentedComment #2
nonprofit commentedInstalling Workflow 6.x-1.x-dev (from 6.x-1.5) solved this issue.
Comment #3.0
(not verified) commentedClarified issue