nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL for Issues Closed in Specific Sprint

unknown

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.

Accepted answers

Svenja Lorenzen

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

All comments

Svenja Lorenzen

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

unknown

@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"

unknown

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!

Slavna Dadic_2gx7vi

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

Marcelo Lopez_mjoh5h

The correct way to do this is to use the Sprint Report (go to Report and select that) to pull the Sprint ID itself.

Select the Sprint you want to get a report from, from the drop-down of Sprints that are closed, and when it's presented, look at the URL itself. And at the very end of the URL, you'll see the Sprint ID, like the following string:

[URL to my project....]/sprint-retrospective?sprint=SprintID

where Sprint ID is a number, like "9405" (without the double quotes).

Then craft your JQL accordingly:

"project = _myProject_ and sprint ="9405" and resolution = Complete and issuetype in (_Whatever IssueTypes you want to retrieve_) order by _Whatever Order you want to order them by_ DESC/ASC"

Since you can export the Sprint Report using the "Issue Navigator" (which selects the SPECIFIC Items from that Sprint), this may be a bit roundabout if you're trying to dump them out.

However, if you're just trying to get a list to report (for example, in a Confluence Page), this query can be very helpful for those purposes.

Enjoy.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql

scrum

sprint

resolution