JQL query to filter a Cascade type field?

Castro Anibal - S170657 September 29, 2023

JQL query to filter a Cascade type field?

The goal is to select any combination of parent & child

1 answer

1 accepted

2 votes
Answer accepted
Tim Kopperud
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 29, 2023

Hi @Castro Anibal - S170657 

You can use cascadeOption(parentOption[, childOption]) and/or use "=" or "IN" operators. It depends on your exact need. See these examples:

city IN cascadeOption(USA, "New York")

city IN cascadeOption(germany, Berlin)

city IN cascadeOption(USA)

city in ("New York", Berlin)

city = Berlin

 You can combine these, and add "NOT" in front of "IN" to exclude options. E.g.:

car IN cascadeOption(Ford, Red) OR (car = BMW AND car NOT IN (Blue, gray, silver))

This should fetch issues containing red Fords and all BMWs that are not blue, gray or silver. 

You can play around with the combinations to get exact issues wanted. 

 

TimK.

Castro Anibal - S170657 September 29, 2023

thanks @Tim Kopperud ! will also be possible to integrate this query as a quick filter in a Kanban Board?

So that you can choose in the filter one option of "parent" and one option of "child" .

It could be two quick filters, one for parent, and one for child (which actually should only show the possible options for the parent selection)

Tim Kopperud
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 29, 2023

Hi @Castro Anibal - S170657

Yes, but it can be many quick filters, which is not too user friendly, if there are many parents and child's in the cascading list. 

I'm not sure your exact need/outcome here. If you use this for actively working within a Kanban (doing "Kanban stuff"), quick filter can be a way to go. If it's for some kind of reporting (e.g., see how many of xyz), I would suggest another approach though. 

 

Edit:

Sorry, I misread your question. After seeing your comment here I understood better what you were asking. You wanted two quick filter dropdown list to select from cascading options. Sorry, I don’t think this is possible.

TimK.

Like Castro Anibal - S170657 likes this
Caio Cesar Covos
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!
April 10, 2024

Hi @Tim Kopperud 

Is it possible to create a JQL that displays tickets where only the value of the parent field is filled in?

Ex (parent is not empty and child is empty)

Thanks

Suggest an answer

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

Atlassian Community Events