View all nodes NOT tagged with an argument term

Unfortunately this is currently not possible with an argument. =(

Could this maybe be achieved with the following patch? I haven't actually tested this, was just a thought I had...

I've created a more complete patch. Does this seem like a good idea? Is the approach I've taken acceptable?

Cleaner patch.

Apologies for not testing the last patch. This one is tested, and seems to work quite well.

Ahh, I missed a few places for many to one arguments. :) New patch attached.

Actually, I've found a few circumstances playing with the taxonomy arguments where this won't work as expected. For example, it will not show nodes that have not selected any taxonomy terms (But are able too) Which it probably should.

Not sure how to solve that just yet, so I'm marking this as CNW.

Let me know if there is anything else that does not work. I'll keep digging. :)

This could be related to the problem I described above. An example might help.

I have a vocabulary "pets" with the terms "cat" and "dog".
I have a content type "People" with the following nodes, tagged as shown.

Jane - Cat
Jake - Cat
Bill - Dog
Beth - Dog
Paul - [NONE] - i.e. the taxonomy is not required, meaning not all people have to have pets. :)

Now, if you create a view of people, with an argument for pets, you would expect that when you don't specify the argument, that all people would be shown. This works fine.
If you then specify you want to see all people who have cats, by passing in an argument, you would see Jane and Jake, this also works fine, and is the default behavior.
The problem comes when you say I want to see all people who DON'T have cats. You would expect the result of that to show Bill, Beth, and Paul. This will however not be the case. Paul will not show up, even though he really should.

This is the problem I'm currently thinking about how to approach. It should be that whenever you select the "Exclude the argument" option, that the view then shows the EXACT inverse of results as to when "Exclude to argument" is not checked. This is currently not so simple because of the way views does its table joins, with INNER etc... This means that before you even think about filtering, the users who do not have "pets" are already excluded.

The only way around this (Without a patch which I'm thinking about a way to write), is to make the "pets" taxonomy required, and add a "no pets" term or something like that.

This does not exactly match the problem you're seeing, but I think it is related. I'll keep playing and post back here when I think I have something.

Thanks for testing.

This could be made by query alter hook. You need to change module name, view name and argument index.

function MODULE_NAME_views_query_alter(&$view, &$query) {
  if ($view->name == 'VIEW_NAME') {
    $argument_index = 0; //Replace this by your argument's serial number

    $where_index = array_search($view->args[$argument_index], $query->where[0]['args']);

    $query->where[0]['clauses'][$where_index] = 'isnull(%s)';
    $query->where[0]['args'][$where_index] = 'term_node2.tid';

    $join = new views_join;
    $join->construct('term_node', 'node', 'vid', 'vid', 'term_node2.tid='. $view->argument['tid']->value[$argument_index]);

    $query->add_relationship('term_node2', $join, 'node');

    $query->distinct = true;
  }
}

Subscribing, still investiging. Would be great if there was an option within taxonomy arguments "Exclude the argument itself with using the depth more or less than 0.
Greetings, Martijn

Hi, May be using the way this was build can help: http://drupaleasy.com/blogs/ryanprice/2008/06/using-views-2-drupal-6-cre... so using php code with views2!
greetings, Martijn

OK folks in this one - is this still valid? If it is, check it against the current release.

No updates in more than 30 days.

For those looking for this solution, #12 works very well. If someone has time, reviewing/fixing up patch #8 is the eventual elegant solution for this problem.

Any news on this? I would love to have this feature. If not how would you use #12? where do you put the code? Thank you.

#733686: Add exclude option to other argument types
This does not work in Drupal 6 & Views 2.x, but a screenshot makes it looks like it does in Drupal 7 & Views 3.x

There is this as well: Views Exclude Previous, though it's not quite as specific.
(I've used it as my solution.)

Many (belated) thanks to gsemko #12. I've spent 3 days trying to work out how to exclude taxonomy terms from a previous pane in subsequent panes. I thought I was heading off down the road of custom views handlers to negate the select. Seemed a bit overkill to change "node.vid IN (SELECT..." to "node.vid NOT IN (SELECT..."!

So now I have two "Taxonomy: Term ID (with depth)" arguments for my view and pass the two sets of term_ids from my panel config. I rewrite the second of those using hook_views_query_alter to be a NOT and all works fine. I did have to set up a default value of 9999 in the view config for the second argument as for my first pane, I don't want to exclude anything.

If anybody needs a deeper explanation, hit me back and I'll expand.