Exclude sprint by its name or ID with JQL?

[Erik Hennerfors]

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

[Matheus Fernandes · Accepted solution]

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!

[Erik Hennerfors]

It worked, thank you