JQL - Specifying a sprint

Chris Warton November 18, 2014

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?

1 answer

0 votes
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 18, 2014

Create a filter like this:

sprint in (sprint_name) AND sprint in OpenSprints()

And then search like this:

filter != filter_that_you_created

Chris Warton November 18, 2014

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

Suggest an answer

Log in or Sign up to answer