I found this article about how to create a Views to display all active taxonomy terms: https://www.drupal.org/node/770782

I want to achieve the exact contrary: Get a list of all terms that are not used by my nodes.

Can I reach this with Views UI, relashionships, etc?

Any clue is welcome!

2 Answers 2


This can be achieved by View relationships and aggregation

1) Add a new view of view type "term"

2) Add Field Taxonomy: Term Name

3) Add Relationship "Taxonomy term: Content with term"

4) In the View : Advanced section , Enable Aggregation

5) Add new Filter nid, Aggregation type = Count DISTINCT , Select Relationship = node , Operator= equal to , Value= 0

  • Many thanks. It works like a charm. I still have some trouble with Views UI understanding, in particular with relashionships and contextual filters. You helped a lot. Thanks again.
    – Djouuuuh
    Commented Oct 14, 2014 at 11:40

Be careful to trust on the proposed solution, if you have unpublished nodes, because unpublished entities do not appear in views

If you use the aggregation view to delete orphaned taxonomy terms, you might loose information of your unpublished nodes. Consider using the "delete orphaned terms" module

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.