i tried "and sprint not in futureSprints()" but that doesn't work to exclude future sprints, looks like the function doesn't work properly unless i am missing something, or the definition of 'future sprint' is not what you and i think of what is future (i.e. everything that is neither current nor closed'
+1 for currentSprint(), though I'm not sure how that would work exactly since there can be multiple currently open sprints, so perhaps instead newestOpenSprint() and oldestOpenSprint() if the sprint start time is tracked
If you have only sprint per project the query below is nice:
sprint in openSprints()
But I have a project with multiple active sprints, how can I differentiate between those?
My goal is to create a filter that shows per sprint, the stories that we added after the sprint started.
What would be nice is something like:
sprint in openSprints('added stories') to show feature creep
sprint in openSprints('removed stories')
Yes. 'sprint in openSprints()' shows only active sprints. I'm not sure if the behavior changed, but this is very handy. This and the futureSprints() function cover most of my use cases.
"sprint in openSprints()" never returns any issues returned by "sprint in futureSprints()".
So, your suggested JQL can be simplified to "sprint in openSprints()", as indicated by the accepted answer.
I want a data field that indicates an issue's current sprint association. Right now the "sprint" field contains every sprint an issue has ever been associated with. This makes sense for long term reporting but it makes it difficult to see which sprint an issue is in right now. The currentSprint() and openSprint() don't provide that information.
If you have multiple open Sprints in your Backlog for forecasting and you want to view only your active Sprint, this JQL works:
project = MIG AND Sprint in openSprints() AND sprint not in futureSprints() ORDER BY status DESC, issuetype
I need to see last 4 sprints. The function currentSprint() would help here if it existed. I don't see how openSprints() can help here, so the original question seems to be still relevant.
You can use closedSprints() to get at issues in past sprints. Not sure about limiting it to the last 4 though, maybe using updatedDate would get you close. Something like:
Sprint in closedSprints() AND updatedDate >= -8w
An open Sprint is any Sprint that is not in a close status. We have several open Sprints because we are Product Roadmapping. I need a search function that only returns the current "Active" sprint that has been "started" and that we are current working in. Open Sprints returns too many issues.
Starting with the 7.2 Jira Agile REST API, you can set properties on sprints. Depending on what resources you have available to you, you could set an "active" property on the desired sprint and update as needed.
Not sure if you can use that in JQL yet like you can issue.property, but if you have ScriptRunner @Jamie Echlin might have a suggestion or two.
I keep getting the error 'An option provided by the function 'openSprints' for the field 'sprint' does not exist.'
We definitely have an active sprint with issues in it.
There seems to be a bit of confusion on the functionality of openSprint()
I think it's because the name suggests that it returns all sprints that are not closed whis includes future sprints. I was also confused by this.
This is NOT the case. From openSprint() documentation it clearly states: "Search for issues that are assigned to a sprint that was started, but has not yet been completed"
So in order to find tasks in the active sprint you only need to write "sprint in openSprints()" no need to exclude future sprints.
Remember: There can be many active sprints. Typically one per Scrum team. Hence you still need to include only the tasks that relates to your team.
See how to use Jira on the go! Demo Den Episode 5 is here: meet Jira Mobile with Jira Product Manager Rayen Magpantay. Demo Den is in our monthly series where a Jira PM demonstrates...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events