Query to find open Epics with closed linked stories & Epics

katie Dennis April 12, 2024

If someone could provide me the query to look for all Open Epics where the issues in Epic are closed and Issue Links - has Epic are also closed.Capture.PNG

1 answer

1 accepted

4 votes
Answer accepted
Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 12, 2024

Hello @katie Dennis 

You need an add-on like scriptrunner for such a query. Do you know if you have it?

katie Dennis April 12, 2024

@Kalyan Sattaluri I don't know if we have that, but I am doubtful. Do you know how I would find out?

Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 12, 2024

In your Issue search section, click advanced and start typing issuefunction .. if your dropdown prompts you with available options, you have that add-on available.. like below screenshot.. Please try and let us know..image.png

katie Dennis April 12, 2024

Yes I do have that :)

Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 12, 2024

Great. Can you tell if all your stories / epics in the same project WCNG? or can you share which project has epics and which projects have stories so I can give sample JQL.

katie Dennis April 12, 2024

Yes all in that project

Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 12, 2024

Hello,

You havent mentioned if you are in cloud or data center, Can you please try below query and tell if you see results.. Replace bolded part (Done) with terminal status of your Epic issue type.

 

status != Done and
issueFunction in linkedIssuesOf("project = WCNG and status = Done", "has epic") and
not issueFunction in linkedIssuesOf("project = WCNG and status != Done", "has epic")

 

 

katie Dennis April 12, 2024

Thank you - that seems to have done the trick! 

Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 12, 2024

Awesome. confession. I just copied it from below link because I had it bookmarked from earlier :p.

https://community.atlassian.com/t5/Jira-Software-questions/Filter-all-Epics-that-are-incomplete-but-only-have-Stories-that/qaq-p/233701

Please review the results and let me know if you see anything odd. If everything looks good, please accept solution so it benefits folks in the future. Thanks!

Like katie Dennis likes this

Suggest an answer

Log in or Sign up to answer