JQL trying to return only the sprint value when issue was closed

[Damon Gaylor]

When exporting my jql out to excel (don't think it matters), the Sprint value contains a list of all of the sprints the story was in.  I only want to see the sprint it was closed in.  

I'm running reports that contain multiple sprints in multiple projects (single backlog).

Any ideas?

[Bill Sheboy · Accepted solution]

Hi @Damon Gaylor 

I do not believe you can do that with out-of-the-box JIRA's JQL.  If you have something like the add-on ScriptRunner I think there is a function to return the closed sprint prior to export.

Without the add-on, I just added a formula to my exported data in Excel to locate the last sprint column containing data, issue-by-issue.

Best regards,

Bill

[Damon Gaylor]

Thanks Bill, I was afraid of that.  I'm not a dev, but I can try something creative in googlesheets.  I'm actually using the Jira ad-on there, which is pretty great.