JQL - Specifying a sprint

Question

I'm trying to write a query for an Agile board and want to specify that an issue needs to NOT be in a current sprint that has a certain name. It can have been in a closed sprint that had that name, but not a current sprint.

But if I use something like this:

sprint not in (sprint_name) AND sprint not in OpenSprints()

it doesn't work - it seems to treat that as:

any of the sprints the ticket has ever been in not in (sprint_name) and any of the sprints the ticket has ever been in not in OpenSprints()

which is not what I want. What I want is:

there is no sprint in which this ticket was that is both in (sprint_name) and in OpenSprints()

Any suggestions?

Chris Warton · Answer

Unfortunately that didn't work - it still excluded the ticket based on its previous sprint.

Jobin Kuruvilla [Adaptavist] · Answer

Create a filter like this:

sprint in (sprint_name) AND sprint in OpenSprints()

And then search like this:

filter != filter_that_you_created