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

6 votes
Accepted answer

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

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!

This really helps in may case. Thanks.

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?

 

 

  

 

 


 

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 Sign up to answer
Community showcase
Published 16 hours ago in Jira

How you can achieve compact and easy-to-maintain workflows in your JIRA( Server)

This approach requires you to have the JIRA administrative rights. The main aim of this article is to help you achieve an organized, easy-to-maintain workflows in your JIRA instance thereby, reducin...

151 views 0 0
Read article

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