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
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.
Thank you for this! Just saved me.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
but when I switch to Advanced mode, it works for me:
Can you share your screenshot? What exactly does not work?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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"
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @subham patra no, I was using only native custom fields...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.