JQL for Issues Closed in Specific Sprint

[Ankit Aggarwal]

Hello! I'm trying to run a query that will only return issues closed in a specific sprint.

Example - I have Issue M-50 that was worked on and closed during Sprint 1, and M-100 that was worked on during Sprint 1 and Sprint 2, and closed in Sprint 2.

I don't want M-100 to appear in the same query as M-50 because M-50 was closed in Sprint 1 and M-100 was closed in Sprint 2. However, M-100 has a Sprint value for Sprint 1 since it moved across sprints.

[Svenja Lorenzen · Accepted solution]

Hi @Ankit Aggarwal,

I think you can use the function "closedSprints()". The function searches for Issues that are assigned to a completed Sprint.

To find find all issues that are assigned to a completed sprint try:

sprint in closedSprints("Sprint 1")

Kind regards,

Svenja

[Ankit Aggarwal]

@Svenja Lorenzen that does not seem to work for me. I'm not sure closedSprints() can be used for that. I'm getting the following error.

Could not resolve the project 'Sprint 1' provided to function 'closedSprints'.

[Svenja Lorenzen]

Hi @Ankit Aggarwal,

I see. I tried the following query and this one worked for me:

project = XXX AND status = "Done" AND sprint = "Sprint 1" and sprint != "Sprint 2"

[Ankit Aggarwal]

Thanks! I had come up with that too but was hoping there was another way in case an issue spanned future sprints as well. I think this is the only way. Appreciate it!

[Ofentse Modisakeng]

 @Ankit Aggarwal 

What will be query in  include all statuses in the previous sprint?
My current j-query displays completed or closed issues only?

see eg:  project = YYY AND issuetype in (Story, Sub-task) AND Sprint = #### AND component = DCS AND component = "ZA/DVS" ORDER BY issuetype DESC