JQL query for not 'done' Issues belonging to certain epics

[Adam Taylor]

Hi all,

I'm looking to find all not 'Done' issues that belong to Epics that are due by a certain date.

I've created a filter to find the Epics that I'm looking for:

issuetype = epic and duedate <= '2023/03/21' and team = 13 and status not in ("Not Required", done)

But the bit I'm stuck on is how I can use the above with a search for not done issues that belong to those epics!

Am I being dense?

[Mark Segall · Accepted solution]

Hi @Adam Taylor - You're not going to get there natively.  Unfortunately JQL does not support layered statements.  You'd need a marketplace app that provides JQL extensions such as Scriptrunner.  With that, you'd be able to do something like this:

issueFunction in issuesInEpics("issuetype = epic and duedate <= '2023/03/21' and team = 13 and status not in ("Not Required", done)")

[Rob van den Belt]

For me this works fine in addition to your own query

AND StatusCategory NOT IN (Done)