JQL to return stories and the latest spring they are in

P_ April 4, 2017

We have many stories that were carried over between sprints. I wonder if there is an option how to get only the latest sprint a story was in? I mean, if the story was in A, B and C, I would need the query to return only C.

1 answer

Are you using JIRA Server or Cloud?

If you are using JIRA server you could add a SIL calculated field (https://confluence.kepler-rominfo.com/display/KCF/SIL+Script+Custom+Field) and filter the values from the sprint field in a loop checking if they are active and/or for the latest end date (https://confluence.kepler-rominfo.com/display/JJUPIN/sprintEndDate).

Do you know the JQL "sprint in openSprints()" to return only issues which are in a currently active sprint?

Suggest an answer

Log in or Sign up to answer