JQL for Custom Field that is a Cascading Select

I am trying to determine the JQL necessary to report on a custom field that is a Cascading Select type. I need to identify issues that have the parent field value of ABC and has a 'child or secondary' list value of 123.

It seems that when I use the JQL based on the custom field, it is only able to query against the parent. How do a do it against the parent's list values like in the example mentioned?

2 answers

1 accepted

4 votes
Henning Tietgens Community Champion Jun 12, 2013

Use

customfield in cascadeOption(parentOption,childOption)

The online help is a great source for advanced searches: https://confluence.atlassian.com/display/JIRA/Advanced+Searching+Functions#AdvancedSearchingFunctions-cascadeOption()

Henning

Thank you - I use that page often...however, I obviously overlooked the section on this type. Appreciate it!

Hi All,

We are using the cascade select field in our filter, we would like to know is there a way we could use multiple parent options in the query.

Parent Option : A has (1,2,3 has child options)

Parent Option B has (4,5,6 has child options)

Parent Option C has (7,8,9 child options)

Parent Option D has (10,11,12 child options)

We are trying to achieve we need results of Parent Option A and C with all the child Options.

When we have seen in the link provided above, we see there is no option of having multiple Parent options. Any information provided will be very helpful.

 

Thanks,

Vijay

Henning Tietgens Community Champion Dec 01, 2016

Maybe you could try "OR" for multiple customfield in cascadeOption() statements in the query...

Henning

@Henning Tietgens - thanks for the reference - I missed it on that page as well.

However, it is not working for me.  The parent seems to work but all children are included, regardless of the child that is entered.  Any ideas?

Oh, oops.  I found my error.  Works!

Somehow I don't get it.
I try to query a cascading select on emptiness but get funny results.

 

Entering nothing into the query tells me I have approx 41k datasets in my instance.

image2017-3-3 12:6:33.png

 

querying my instance to return all datasets having the cascading select field empty yields 10

image2017-3-3 12:8:15.png

but querying for not empty returns only approx 2k datasets

image2017-3-3 12:9:11.png

where are the remaining 39k datasets?

 

 

  

 

 


 

Henning Tietgens Community Champion Mar 03, 2017

Is "Module Selection" available for every possible project/issuetype combination? Is your index current?

Thanks a lot Henning, this helped smile

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,316 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot