Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Equivalent of "ONLY IN" using JQL

Eric Christenson
Contributor
September 14, 2018

I have issues that expand across multiple sprints. I want to search for issues that only exist in certain sprints. Something like (pseudocode):

project = FOO AND sprint ONLY IN ("Sprint 44")

Is this possible? Thanks.

3 answers

1 accepted

2 votes
Answer accepted
Gonchik Tsymzhitov
Contributor
September 17, 2018

It is not possible from out-of-the-box jql function.

0 votes
Gerard Veenhof
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 4, 2023

So I got here from Google and I wanted to share what works for me, if you only have 1 open sprint you could use:

status = Done and Sprint in openSprints() and Sprint not in closedSprints()

Will only show 'done' from the openSprint. 

Eric Christenson
Contributor
September 14, 2018

I tried that approach and it will return issues outside of the selected sprint. For example:

project = foo AND sprint IN (123)

might return:

Key          Status    Sprint
Issue-123    DONE 122, 123, 124
Gonchik Tsymzhitov
Community Champion
September 14, 2018

Looks like it is not possible.

Eric Christenson
Contributor
September 17, 2018

@Gonchik TsymzhitovPlace this statement in a separate answer and I'll mark it as the "solution". Thanks.

Suggest an answer

Log in or Sign up to answer