nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL Filter: Show all Initiatives where every epic is closed

Tom_h26dqq

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?

Accepted answers

All comments

arielei

Hey @Tom

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

Tom_h26dqq

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_h26dqq

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

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-

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,

Tom_h26dqq

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?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud