Query for finding all Story or other Issues in Epic that are NOT closed

[Katherine Lord]

Query for finding all Story or other Issues in Epic that are NOT closed but linked to an Epic that is closed

project = "abc" AND (type = Epic OR type in (Bug, Story, Task) AND "Epic Link" is EMPTY) AND type = epic AND status in (Closed, Verified, Done) ORDER BY issuetype DESC

[Jack Nolddor _Sweet Bananas_]

Hi,

Sadly there is no out-of-the-box way to perform such a complex query, you must go for a third-party app instead.

Using i.e JQL Booster Pack (FREE), you must type the following:

Search unresolved issues within resolved Epics

issue IN issuesInEpics("resolution is not EMPTY") AND resolution is EMPTY 

Kind Regards

[Katherine Lord]

Thank you for your quick response.  I have tried the addon and query and no results yet I have some I manually found when searching at Closed Epics that still has Links in Epic not closed.

[Jack Nolddor _Sweet Bananas_]

Hi Katherine,

My previous filter relies on the resolution field. if by "Closed" you mean a Green Status you can use the following query instead:

issue IN issuesInEpics("statusCategory = Done") AND statusCategory != Done

Regards