Complex View Involving Separate Entities / Taxonomy Vocabulary / Content - Distinct

Question

Given the following Content Type: Smartphone

Taxonomy Vocabulary: OS: Android / iOS / Windows / Blackberry

Taxonomy Vocabulary: Color: Red / Blue / White / Black / Yellow

OS and Color is a Taxonomy Vocabulary which is term referenced in the content type smartphone.

Now the question is:

How do you setup a view to display only the COLORS that are available for the Android OS? I do not care about what phone it is. Example of this contextual path would be: example.com/android-colors

That in effect would just give me a list of all available colors that androids are in. Since OS and color has no direct relation, you would have to create a view of smartphones then GROUP THEM BY color while the contextual filter grabs the %android% arguement via the path.

The problem with this is that there will be thousands of records since each result is unique since your querying the smartphone table. Distinct setting in the query dialog box does not apply since each result is technically not distinct.

Answer 1

You can cheat a little and use Views Limit Grouping to help do this.

I created a view of smart phones with the path being smart-phones/%/colors. The only argument I need is for the OS. Add a contextual filter for the mobile OS using "Content: Has taxonomy term ID", filter by the term name. Under your fields to be shown, just select the color.

Using the Group Field (with Limit) formatter, we'll group by the color and show 0 items. Now if there are smart phones that have a color selected, it should show up in this list. In my screenshot you can see that I am only showing Blue and Orange, but in my taxonomy I actually have Blue, Green, Orange, and Red available - but I have no phones that are Red or Green.

From here, all you need to do is rewrite the color url to go to whatever other view you would like, such as smart-phones/%OS/%Color