How to display only taxonomy terms with nodes associated to in Views 2?

drupal views drupal-views
Leandro Ardissone picture Leandro Ardissone · Jan 7, 2009 · Viewed 10.1k times · Source

I've created a view with a set filters exposed (to show filtering options in the page). And one of those filters is a select field with all the taxonomy terms of a vocabulary.

That's ok, it's showing now. But I want to only show the taxonomy terms that have at least one node associated to it. To avoid empty results if selects an empty term.

Anyone knows how to do that?

Thanks.

Answer

sphism picture sphism · Feb 5, 2012

Solution in views 3 (which may work in views 2)

Set a relationship for the view to join the terms to the nodes (in views 3 this is 'Taxonomy term: Content with term')

Then in the options tick 'Require this relationship' (this excludes terms without any nodes)

This may produce duplicates, in views 3 you open up Query settings, and tick Distinct (this will omit duplicates)

Related questions

custom page.tpl.php for a drupal view

How can I create a custom page.tpl.php for a specific view? I'm not talking about styling the view itself, just the page where that view gets rendered. Thank you. @Keith Morgan - It's page.

Read More
Drupal Views: Get nodes with the same taxonomy as the current node

I have a Content-Type with taxonomy-terms. It's a select-list, so it can have only one taxonomy - at least of that vocabulary. Now I need to build a view that lists all nodes with the same taxonomy. Thought that this …

Read More
Drupal : how to sort and display nodes grouping by first letter in view

I have a huge list of companies (nodetype : company, only field is title) that I want to display in a nice way groupping them by first letter like a dictionnary like this : A Abc company Alot of work company B …

Read More