Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to Exclude a Status of One Issue Type using JQL

Kayla Kozlowski (DISH)
Community Champion
February 2, 2023

I am trying to make a Kanban board for my team that is swimlaned by epics, but the filter I am using is including epics in a done or canceled state. 

 

When using JQL and trying to exclude closed epics, it is removing closed stories as well. We want to keep closed stories in our filter and remove closed epics, but they share the status "Done". 

 

Is there a way JQL can exclude a status of one issue type even though it shares statuses across other issue types?

2 answers

1 accepted

1 vote
Answer accepted
John Funk
Community Champion
February 2, 2023

Hi Kayla - Welcome to the Atlassian Community!

Try project = ABC AND issuetype != Epic OR project = ABC AND issuetype = Epic AND statusCategory != Done

Rafael Corredor
Contributor
February 2, 2023 edited

Hi,

It probably works without (), but my recommendation is to use them to clarify the conditions and avoid errors in future when updating the query with a new condition...

Kayla Kozlowski (DISH)
Community Champion
February 3, 2023

Thank you, John! This provided the correct results using JQL.

Like • John Funk likes this
John Funk
Community Champion
February 3, 2023

Great! And happy to help. 

0 votes
Rafael Corredor
Contributor
February 2, 2023

Hi,

Yes, it is a secondary effect if you use epics as swimlanes.  You can try using another swilane condition.

I assume the closed stories are associated to those closed epics.  If you are missing other closed stories... then probably the filter has an error (maybe you need to add some () to restrict results: (issuetype = epic and status not in (done, canceled)) OR ....

It would be great is you include your current filter conditions

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
atlassian, likes for trees, atlassian community, social impact, tree planting campaign, community kudos, atlassian giving, environmental impact, sustainability, likes for good, atlassian social responsibility, community challenge

Make every click count—help us plant 50,000 trees! 🌳

Want to make your everyday Community actions directly contribute to reforestation? The Atlassian Community can achieve this goal by liking a post, attending an ACE, sending your peers kudos, and so much more!

Help us plant more trees
AUG Leaders

Atlassian Community Events