How to Exclude a Status of One Issue Type using JQL

[Kayla Kozlowski (DISH)]

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?

[John Funk · Accepted solution]

Hi Kayla - Welcome to the Atlassian Community!

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

[Rafael Corredor]

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

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

[John Funk]

Great! And happy to help. 

[Rafael Corredor]

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