Open sub-tasks closed parent

[chris.naylor@coveainsurance.co.uk]

Using Jira cloud and trying to find a JQL or way to show all open sub-tasks where the parent has been closed without using any add ons. 

[mauricio.groth]

Hi chris.naylor@coveainsurance.co.uk 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all subtasks that are in progress and have finished parents

issue in subtasksOfParentsInQuery("status='Done'") and status != done

Check out the documentation for more examples.
I hope this helps!
Maurício

[Jack Brickey]

unfortunately this isn't possible without an addon app.

[Max Foerster - K15t]

Hey chris.naylor@coveainsurance.co.uk,

Unfortunately, this is a quick one to answer. It's impossible to achieve that in Jira without using Marketplace apps that extend JQL. The good thing is that there are appropriate apps available on the Atlassian Marketplace (Marketplace Search "JQL" for Jira Cloud)

Best, Max

[chris.naylor@coveainsurance.co.uk]

Thanks, I thought that might be case. 

[Max Foerster - K15t]

Yeah, it would've been great. But hey, there's one thing you should bookmark if you haven't already. The documentation on JQL is pretty awesome. To me, it feels like the best-documented feature in general. So if you're looking for something specific (fields, functions, etc.), head over to What is advanced searching in Jira Cloud?. You can navigate to lists containing all fields, functions, keywords, and operators on the top right.

Best, Max