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

Question

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] · Answer

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

Katherine Lord · Answer

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] · Answer

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