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; } } }

Can a JIRA query be written to retrieve issues contained in Sprints closed within a date range?

I am trying to retrieve issues (stories, subtasks) that were contained in Sprints that were closed between 2020-01-14 (Jan 14th 2020) and 2020-11-23 (Nov 23rd 2020). I don't see a field such as Sprint Closed Date available.

If it did exist, I could add a clause like this:

AND SprintClosedDate between 2020-01-14 and 2020-11-23

Can a JIRA query to do something like that?

Accepted answers

All comments

you should be able to just simply use sprint not in opensprints() and resolutiondate between the dates that you want

Follow-ups question: What is the date format? CCYY-MM-DD?

In other words, would it look like this?

Sprint not in openSprints() AND (resolutiondate >= 2020-01-14 AND resolutiondate <= 2020-11-23)

Actually I think that is it... Thanks for the help?

help! (that is)

Welcome!

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

Quick Links

Find more posts tagged with

jira-software

jql

advanced-search