When applying filters in views, we want to be able to see only relevant values. This is easily achievable on forms, but the filtering views does not allow us to see only relevant values. Here's a scenario, to illustrate the point:
We created 3 custom columns in the Account table:
- Economic Sector:
- Information & Communication Technology
- Financial
- Mining
- Sector:
- Mobile
- Fixed Line
- Banking
- Insurance
- Investment
- Forestry
- Fisheries
- Geo Mining
- Sub-Sector:
- Mobile Phones
- Mobile Accessories
- Exchange Equipment
- VOIP Phones
- Cordless Phones
- Coal Mining
- Gold Mining
- Diamond Mining
These fields have a contextual, hierarchical relationship, that works perfectly on the form, but not when we are filtering in views.
On the form, for example, when we select Mining in the Economic Sector, then the Sector shows only the fields related to mining - Forestry, Fisheries and Geo Mining. When we select Geo Mining in the Sector, then the Sub-Sector shows only the relevant values - Coal Mining, Gold Mining and Diamond Mining. Perfect.
When we want to filter our list of Accounts, we see all the Economic Sectors, Sectors and Sub-Sectors displayed, regardless of what filters we have already applied. When we select the Economic Sector Mining, for example, the Sector shows all sectors and not just the ones that are related to Mining.