nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL to find specific cascading list child value

erika_zanoni

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

Accepted answers

Martin Bayer _MoroSystems_ s_r_o__

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?

Richard Burstiner

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.

All comments

Martin Bayer _MoroSystems_ s_r_o__

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

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__

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:

subham patra_yc9wo2

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

Richard Burstiner

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.

Basically:

cascadeOption(parentOption,childOption)

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

Stanley Duback

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.

Hannah S

Thank you for this! Just saved me.

Matt Lane_ii5ifz

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

jira-cloud