JQL filter issues by Parent Status

Federico Varchavsky
Contributor
March 30, 2023

Hello,

 

I need a filter that I can use which shows all the issues that belong to a project and in which the parent status != Done.

 

Something like this one... but having the status filter limited only to the parent (not all the issues):

project = myProject AND status != Done AND Sprint in openSprints() ORDER BY key ASC, parent ASC, Rank ASC

 

Basically: only hide anything with a parent status = Done... and show all else.

Even issues in Done should be shown as long as their parent's not in Done status.

 

Thanks!

Federico.

1 answer

2 votes
Mark Segall
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 30, 2023

Hi @Federico Varchavsky - Unfortunately, you cannot get something like this with native JQL.  There are marketplace apps that provide JQL extensions which would be able to provide this capability.

Federico Varchavsky
Contributor
March 30, 2023

Nooooooo!

This is terrible for my organization... both personal and corporate organization. hehehe.

 

Is there any way to concatenate different filters?

 

Like having a filter which only show the US i need... and in another filter having all the issues the belong to that filter I just created.

Something like:

 

myUSFilter = shows all the US that I need to find

myIssuesFilter = show me all the issues which IN myUSFilter

 

Thanks Mark!

Mark Segall
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 30, 2023

Unfortunately not.  You're looking for the ability to establish subqueries which native JQL just isn't advanced enough to handle on its own.

Federico Varchavsky
Contributor
March 30, 2023

:( Thanks @Mark Segall  for your prompt response!

Like Mark Segall likes this
Anders Borud
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 18, 2024

For anyone else looking for a solution, I solved this by creating a Jira automation that adds/removes a label to all sub tasks when the parent is transitioned to a specified status. Then you can just use that label for filtering. See attached photo for automation example.

jira_automation.png

Like # people like this

Suggest an answer

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

Atlassian Community Events