Search Cascade Options from Search Bar

[Mark Cogan]

I've seen answers that involve using command line JQL queries.  But I have help desk personnel that only access via the application.  They need to be able to search not just the primary option, but the secondary option in a cascade as well.  For example:

Problem Type = Hardware

problem sub-type = monitor

Our tech needs to pull up all the monitor type hardware issues in Search query.  How do they go about getting the sub-type?

[Tessa Tuteleers]

Hi @Mark Cogan , 

It's not possible to query on this with the basis search. But if you go to advanced search you can type a JQL for it (in the UI). 

Basically what you can do is filter on the first part of the cascade separately from the second part. The first part would give the tickets with that value from the cascade, no matter the second part. The second part would give all issues that have that value in the second part of the cascade, no matter the first. So what you need to do, is ask the issues that have the first part AND the second part. This would look something like this: 

(in my example, notice i query twice on the same field. first for the type, then on the subtype, and i get a list of those issues)

In your case this would look something like this: 

"problem type" = hardware AND "problem type" = monitor

Hope this helps! 

 Tessa

[Mark Cogan]

I figured it out.  My user needed to enter the entire sub-field for the problem type, and it doesn't start with monitor.  Thanks for getting me on the right track.  

[Tessa Tuteleers]

Hi @Mark Cogan , 

glad you figured it out! 

Have a great evening, 

Tessa

[Guilhem Dupuy]

Hello,

In JQL, you can access the problem Type using : 

cascadeOption(parentOption)

 and you can access the sub-type by using :

cascadeOption(childOption)

Let me know if it helped or not,

Guilhem