Closed (duplicate)
Project:
Views (for Drupal 7)
Version:
6.x-2.8
Component:
Miscellaneous
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
28 Nov 2009 at 04:22 UTC
Updated:
4 Apr 2010 at 03:38 UTC
Maybe its the lack of sleep, or something is indeed not working here.
I have a vocabulary that has, lets say 10 terms in it. But I only want to display nodes from 9 terms. Therefore, under Filters, I first added "Taxonomy: Vocabulary", set the operator to "is one of" and selected the said vocab. Then I added "Taxonomy: Term ID", set the operator to "is none of" and selected the term I want excluded.
With that I expected Views would first filter nodes from the selected vocab, then further filter nodes that are not from the selected term. But apparently it didn't work, instead it hogged up my server resource and time out eventually.
What have I missed here?
Comments
Comment #1
dawehnerCould you please export the view, so its possible to see what you have done?
Comment #2
dawehnerThats the wrong status
Comment #3
deanloh commentedThanks for responding. I'd eventually changed plan and not needing this solution for now. I will try to replicate the problem in a different set up another time. Thanks for offering help anyway.
Comment #4
dawehnerClosed, because of no response since 4 months. Feel free to reopen the issue again, if you have new informations / the bug still exists.
Thanks.
Comment #5
mcarbone commentedI'm having this exact problem. It only happens with "is none of" -- it works fine with "is all of". The view:
$view = new view;
$view->name = '[Name]';
$view->description = '[Description]';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'term_data';
$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(
'tid' => 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,
'set_precision' => FALSE,
'precision' => 0,
'decimal' => '.',
'separator' => ',',
'prefix' => '',
'suffix' => '',
'exclude' => 1,
'id' => 'tid',
'table' => 'term_data',
'field' => 'tid',
'relationship' => 'none',
),
'name' => array(
'label' => '',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 1,
'path' => 'site-based/[tid]',
'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,
'link_to_taxonomy' => 0,
'exclude' => 0,
'id' => 'name',
'table' => 'term_data',
'field' => 'name',
'relationship' => 'none',
),
));
$handler->override_option('sorts', array(
'name' => array(
'order' => 'ASC',
'id' => 'name',
'table' => 'term_data',
'field' => 'name',
'override' => array(
'button' => 'Override',
),
'relationship' => 'none',
),
));
$handler->override_option('filters', array(
'vid' => array(
'operator' => 'in',
'value' => array(
'17' => '17',
),
'group' => '0',
'exposed' => FALSE,
'expose' => array(
'operator' => FALSE,
'label' => '',
),
'id' => 'vid',
'table' => 'term_data',
'field' => 'vid',
'relationship' => 'none',
),
'tid' => array(
'operator' => 'not',
'value' => array(
'129' => '129',
),
'group' => '0',
'exposed' => FALSE,
'expose' => array(
'operator' => FALSE,
'label' => '',
),
'type' => 'select',
'limit' => TRUE,
'vid' => '17',
'id' => 'tid',
'table' => 'term_data',
'field' => 'tid',
'hierarchy' => 0,
'relationship' => 'none',
'reduce_duplicates' => 0,
),
));
$handler->override_option('access', array(
'type' => 'none',
));
$handler->override_option('cache', array(
'type' => 'none',
));
$handler->override_option('title', '[Title]');
$handler->override_option('header', '[Header]');
$handler->override_option('header_format', '3');
$handler->override_option('header_empty', 0);
$handler->override_option('items_per_page', 0);
$handler->override_option('style_plugin', 'list');
$handler->override_option('style_options', array(
'grouping' => '',
'type' => 'ul',
));
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->override_option('path', 'site-based');
$handler->override_option('menu', array(
'type' => 'none',
'title' => '',
'description' => '',
'weight' => 0,
'name' => 'navigation',
));
$handler->override_option('tab_options', array(
'type' => 'none',
'title' => '',
'description' => '',
'weight' => 0,
));
Comment #6
jennycita commentedMarking as a duplicate of http://drupal.org/node/536692.