Help writing JQL

[Chris Archey]

Hello,

I'm looking for some help to write a JQL that will search all projects, where the result is all Epics that have a status other than done. 

Thank you in advance. 

[Dave Rosenlund _Trundl_]

Welcome to the community, @Chris Archey   👋

You may want to (should) be a lot more sophisticated than this for many reasons. For one thing, if you have a lot of Epics in Jira, this will be a taxing search.

But here's the simplest version I can think of:

issuetype=Epic AND statusCategory != Done

Be careful,

-dave

[Kian Stack Mumo Systems]

@Chris Archey, 

Welcome to the community! Hopefully this helps!

issuetype = Epic and status not in (Done)

If you want to learn more about Issue Searching and JQL, check out this documentation!

[Ragavendran S]

project in ("*")
AND issuetype = Epic
AND status != Done

[vaibhav raverkar]

Try this buddy

type = Epic and Status not in (Done, Cancelled)

You can club it with other status as well, just take precaution if used two word status like To do

type = Epic and Status not in (Done, Cancelled, "To Do")