JQL - filter "To Do" or "In Progress" tasks/subtasks that Epic is not in "Done"

[Kazumi Kerr]

Hello,

I would like to filter tasks/subtasks that status is "TO DO" or "IN PROGRESS" but also the Epic is not "DONE".

I tested this query, but it did not give me what I desired:

project = 12345 AND issuetype not in (Epic) AND status not in (Done) and "Epic Status" != Done

Does anyone know why?

[Bill Sheboy · Accepted solution]

Hi @Kazumi Kerr 

You cannot perform such a query with out-of-the-box Jira JQL features.  Specifically, you are trying to check fields of the epic and excluding epics from the query.  Such queries require correlating different query expressions to join the epic and non-epic information.

If you need this type of query infrequently, you could perform it in steps or export your issues to another tool (like a spreadsheet) for performing the analysis.

If you need this often, please investigate marketplace options to enhance the features of JQL.

Kind regards,
Bill

[Kazumi Kerr]

Thank you, Bill.