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

dawehner’s picture

Status: Active » Needs review

Could you please export the view, so its possible to see what you have done?

dawehner’s picture

Status: Needs review » Postponed (maintainer needs more info)

Thats the wrong status

deanloh’s picture

Thanks 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.

dawehner’s picture

Status: Postponed (maintainer needs more info) » Closed (fixed)

Closed, because of no response since 4 months. Feel free to reopen the issue again, if you have new informations / the bug still exists.

Thanks.

mcarbone’s picture

Version: 6.x-2.7 » 6.x-2.8
Category: support » bug
Status: Closed (fixed) » Active

I'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,
));

jennycita’s picture

Status: Active » Closed (duplicate)

Marking as a duplicate of http://drupal.org/node/536692.