JQL for Issues Closed in Specific Sprint

[Deleted user]

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 @[deleted],

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

[Deleted user]

@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 @[deleted],

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"

[Deleted user]

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]

 @[deleted] 

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

[Slavna Dadic]

HI @[deleted] i know i am really late to the party - neither of these solutions worked for me but what did work is actually using fixVersion instead. Our setup is that each sprint is separate production deploy and that means separate fix version as well. So when i want to query what was done (closed) in a specific sprint i just use fixVersion = 12345