How to do "has term (with depth)" filter on field of a related field

Question

i have a content type 'product', and two taxonomy lists 'company' and 'country'.
Country list has one level of depth like:

........
state1
-city1
-city2
........

Each product has a 'company' field. Each 'company' term has a 'country' field.
I'm trying to create a view for 'product', filtering by 'country'.
By adding the relationship "content: Company" i have only "taxonomy term: field_country" filter without depth.
There is a way to filter with depth like "Has taxonomy term (with depth)" ?

I'm on drupal 7

Answer 1

You would not require a Relationship, just two Contextual Filters.

Based on your requirements Company would be one Contextual Filter - Content: Has taxonomy term ID and Country would be a second Contextual Filter - Content: Has taxonomy term ID (with depth).

Answer 2

In D7, you can only do that with the node table (the content).

If you want to have a working solution for every entity of your system, you have to use this module.

Once installed, don't forget to rebuild the index of your entities, then, in views, you'll have the possibility to add a new relationship ('Taxonomy Entity Index: Taxonomy terms on User') and a filter with depth ('Taxonomy Entity Index: Has taxonomy terms on User (with depth and indexed in taxonomy_entity_index)').