Query to find open Epics with closed linked stories & Epics

[katie Dennis]

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.

[Kalyan Sattaluri · Accepted solution]

Hello @katie Dennis 

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

[katie Dennis]

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

[Kalyan Sattaluri]

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..

[katie Dennis]

Yes I do have that :)

[Kalyan Sattaluri]

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]

Yes all in that project

[Kalyan Sattaluri]

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]

Thank you - that seems to have done the trick! 

[Kalyan Sattaluri]

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!