JQL to find specific cascading list child value

erika_zanoni March 15, 2021

Hi,

I need to do a jql to find an issue that have the second level of a cascading list set to a specific value.

I tried that: 

project = JIRACM-test AND type = "Drop" AND "FactorySistemaMap[Select List (cascading)]" = SDP

but I have no suggestion from jira for the second value(like .child or something like this)

how to do?

 

Thanks

3 answers

2 accepted

9 votes
Answer accepted
Richard Burstiner
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 24, 2022

Sorry to bump an old post but I got to this page today and also found a better solution using built in JQL with no plugins.

The cascadeOption() allows you to search the child option. See https://confluence.atlassian.com/jiracoreserver0818/advanced-searching-functions-reference-1082267989.html#Advancedsearchingfunctionsreference-cascadeOptioncascadeOption()

Basically: 

cascadeOption(parentOption,childOption)

 The documentation has really good examples about how to deal with null values too.

Hannah S
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 8, 2023

Thank you for this! Just saved me. 

Like Heidi Lobecker likes this
3 votes
Answer accepted
Martin Bayer _MoroSystems_ s_r_o__
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 15, 2021

Hi @erika_zanoni I'm just testing it. It looks like "Basic" view does not work well, because it just shows "Any" in the select list:

Screenshot from 2021-03-15 14-27-24.png

but when I switch to Advanced mode, it works for me:

Screenshot from 2021-03-15 14-28-22.png

 

Can you share your screenshot? What exactly does not work?

erika_zanoni March 15, 2021

Hi @Martin Bayer _MoroSystems_ s_r_o__ 

I think in that way, if a value is present both for first and second level of the cascading list the jql return both the issue, I need to get only the issue that have the specific value in the second level of the cascading list, not in the first

Martin Bayer _MoroSystems_ s_r_o__
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 16, 2021

Hi @erika_zanoni , I'm sorry for late response. You can do it using AND logical operator. For example if you have cascading options for field "My Cascade Field"

  • A
    • B
  • AA
    • B
  • C
    • B

And you need to get only AA -> B, you can create JQL:

"My Cascade Field" = AA AND "My Cascade Field" = B

Attaching few screenshots with real usecases:

 

Selection_185.pngSelection_184.pngSelection_183.pngSelection_182.png

subham patra
Contributor
February 2, 2022

Hi @Martin Bayer _MoroSystems_ s_r_o__  - Do you have any add-on installed which supports "Category and Sub-Category [Select List (cascading)]" JQL function? As I tried the same on our server, I got the below error. 

Here "Category and Sub-Category" is a Cascading field name and have global admin permission too. 

JQL error.JPG

Martin Bayer _MoroSystems_ s_r_o__
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 3, 2022

Hi @subham patra no, I was using only native custom fields...

0 votes
Stanley Duback
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 17, 2023

You can query child items in cascading lists with the same syntax

If you do JQL = [Select List (cascading)] = Parent Item AND [Select List (cascading)] = Child item you will get the query narrowed down.

Matt Lane
Contributor
November 5, 2024

What if the child is None / Empty ? but the Parent item is selected

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events