Function in JQL for current sprint?

If I had a filter that always dealt with the latest sprint, is there a way to eliminate my hard-coding the current sprint name?

Ex: Project = WA and Sprint = currentSprint() ?

9 answers

1 accepted

This widget could not be displayed.
You should use this : sprint in openSprints ()

Seems to do what I need, thanks!

I believe this includes active and future sprints. Can you exclude future sprints?

confirming it does include future sprints, i would love to know how to exclude them

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, this needs to be fixed. How about a function currentSprint() instead of open sprints.

+1, there needs to be currentSprint()

+1 for currentSprint() of some kind, just got this request from our web team today

+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

+1 for CurrentSprint() Would also to add CurrentActiveSprints() which should work on the Active Sprints Scrum Board and utilize the sprints which are selected

+1, this would also resolve my issue of finding items that are not in the currentSprint()

https://answers.atlassian.com/questions/37031593

 You can use "AND sprint in openSprints() and sprint not in futureSprints()"

+1 for currentSprint() or activeSprints(), openSprints() is not intuitive and doesn't match  the terminology used elsewhere in Jira. 

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

maybe even:

sprint in openSprints('removed stories') 

This widget could not be displayed.

Just realized you can use "sprint in openSprints() and sprint not in futureSprints()" to get only the current sprint

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.

Yay, this worked for me! thanks!

"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.

This widget could not be displayed.

project = REPLACE_WITH_YOUR_PROJECT_ID AND sprint in openSprints() AND status in (Open, "In Progress") ORDER BY priority DESC, updated DESC

This widget could not be displayed.

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.

Completely agree, Joey, that this would be useful. Ideally, the team finishes all stories in one sprint, but that doesn't always happen.

+1, this would be really useful for us. A distinction between sprint history and current sprint is really important, currently it's all rolled into one.

This widget could not be displayed.

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

This widget could not be displayed.

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
This widget could not be displayed.

What about open sprints of current project or of a specific project (like openSprints(current project) )?

This widget could not be displayed.

 currentSprint() not working for me 

 

Error : Unable to find JQL function 'currentSprint()'.

Thomas Schlegel Community Champion Aug 23, 2017

a function called currentSprint() does not exist. OpenSprints() is what you are looking for.

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.  

This widget could not be displayed.

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.

Are you using 'sprint in openSprints()' in the JQL search?

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted 14 hours ago in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

41 views 1 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you