Help writing JQL

Chris Archey
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 24, 2024

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. 

4 answers

2 votes
Dave Rosenlund
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 24, 2024

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

 

 

2 votes
Kian Stack Mumo Systems
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 24, 2024

@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!

0 votes
Ragavendran S April 24, 2024

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

0 votes
vaibhav raverkar April 24, 2024

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")

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events