Exclude sprint by its name or ID with JQL?

Erik Hennerfors October 5, 2014

Hi
I'm setting up a project that is using booth Scrum and the Kanban boards, the Kanban board is filteret by issues in a sprint named Kanban.

The problem I'm having is that these issues also lives in the Scrum board, so I need do exclude the "Kanban" sprint from ever showing in the Scrum board.

I've tried everything I could find.

Like:
project = projectname AND sprint != Kanban ORDER BY Rank ASC
project = projectname AND NOT sprint in (Kanban) ORDER BY Rank ASC

1 answer

1 accepted

1 vote
Answer accepted
Matheus Fernandes
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
October 5, 2014

Hi Erik,

Could you tell us what happens when you try those filters? What is wrong with the output?

I imagine you'd need to try adding 'or sprint is empty' to your query:

project = 'projectname' AND (Sprint not in ("Sprint Name") or Sprint is EMPTY)

 

Let me know if this helps! smile

Erik Hennerfors October 10, 2014

It worked, thank you smile

Suggest an answer

Log in or Sign up to answer