JQL Filter: Show all Initiatives where every epic is closed

[Tom]

Hello all!

I would like to create a filter, where I can see all initiaitves of my project that are not closed, but in which every epic is closed, so I can adjust the status of the initiative manually - yes, I want it like that.

Im a beginner and tried to inform myself but I really dont understand much.

Could you please help me?

[Cristiano Alves -Appfire-]

Hello @Tom ,

Cristiano from Appfire Team here.

This is not available in native Jira.

The app our team works, JQL Search Extension for Jira enables this search using the following query:

IssueType = "Initiative" AND Status = Open
AND issue IN parentsOfIssuesInQuery("Project = 'X' AND IssueType = Epic AND Status = Closed")
AND issue NOT IN parentsOfIssuesInQuery("Project = 'X' AND IssueType = Epic AND Status != Closed")

After executing this search, you can save it as a reusable filter for access outside the JQLSE environment.
For further assistance with the query or application, please reach out to our support team.
Best regards,

[Karan Sachdev]

Hey Tom,

Welcome to Atlassian Community!

We don't have a way to search this using native JQL.

However, going forward, you can consider writing an automation rule to automatically close the Initiatives when all Epics are closed.

Here's the automation template that should help: https://www.atlassian.com/software/jira/automation-template-library/rules#/rule/140671

Thanks!

[Cristiano Alves -Appfire-]

--

[Tom]

Hi Karan!

I dont understand, why its not possible to do a simple search like this?

It worked in the old Data Center Jira, so why not in the new Cloud?

KR

[arielei]

Hey @Tom 

You cant do this with a normal JQL, do you have ScriptRunner installed?

[Tom]

yes i have!

thx

[arielei]

Hey @Tom 

So open the "ScriptRunner Enhanced Search" and type:

issueFunction in childrenOf("issuetype = Initiative and Status not in (Closed,Done)") and issuetype = Epic and Status not in (Closed,Done)

After it will find the work-items, you can save the filter and call it under a regular JQL statement.

for example if you save the ScriptRunner filter under name "Example"

In JQL write:

filter = "Example" 

[Tom]

Thank you very much!

I did as you said, but now the EPICs are shown. I would like to see the initiaitves, that only have closed epics.

thx and kr

[Tom]

Hi @arielei

dont you have any other idea how to edit this command, so it will show me initiatives instead of epics? 

[arielei]

Hey @Tom 

Try this one:

issueFunction in parentsOf("issuetype = Epic and status in (Closed,Done)", "all") and status not in (Closed,Done)