How to search for all objects based on a dependent object

[Tim Jedlicka]

How do I create a query to return all the dependent tickets?

Let's say I have an insight structure of 

Country (German, US)
     -> Make (VW, Audi, Ford) [dependent attribute of Country]
          -> Model (Golf, Jetta, A4, F150) [dependent attribute of Make]

German              US
   VW                       Ford
        Golf (3)                  F150 (5)
        Jetta (4)          Chevy
   Audi                          Tahoe (2)
        A4 (2)

Number of tickets are in (x). I would like to be able to find all JSM/JIRA tickets for "German vehicles" or "VW" or just "Golf" tickets. So the query for German tickets should return a total of 9. US=7, VW=7, Ford=5, ...

[Tim Jedlicka · Accepted solution]

The following JQL examples are working. "Model-InsightTest" is the name of the custom insight field in the CARS JIRA Project.

To find all tickets in project CARS for Germany:

project = CARS AND Model-InsightTest in iqlFunction("Country = German") 

To find all tickets for Ford:

project = CARS AND Model-InsightTest in iqlFunction("Make = Ford")