nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

John Funk

Hi Kayla - Welcome to the Atlassian Community!

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

All comments

John Funk

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,

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

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud