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

Damon Gaylor_v7l9gn

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

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