find issues closed in a specific sprint (when issues span multiple sprints)

Glenn Van Houten

I need a query that results all of the issues closed in a specific sprint.

I started with  this query:
project = LY AND component = UX AND status in (Resolved, Closed, Done) AND sprint = 1677

This would work if all of our issues only had a single sprint value, but we have some issues that have either spanned multiple sprints or have been pulled out of one sprint and added to a later one. The query above lists issues that were in the specified sprint even if they were closed in a later sprint.

I could go back and delete sprint values, but I like to have them for historical reference so we can see how many issues took longer than a single sprint. I'm also hoping to not have to enter specific date ranges.

Tuncay Senturk _Snapbytes_

Hello,

First I recommend to use "resolution is NOT EMPTY" rather than "status in (Resolve, Closed, Done)"

Anyway, you can add "resolutiondate >= 'yyyy-MM-dd' and resolutiondate <= 'yyyy-MM-dd' " to see whether the issue was fixed within sprint's interval. But you need to know sprint's date.

I am not sure but, below JQL in Script Runner may help as well

issueFunction in completeInSprint("Board name", "Sprint name")