Filter closed tickets by date/period

[Kseniia]

Could you please help me with JQL syntax to find closed tickets per certain period of date?

I tried:

• resolved >= 2021-09-01 AND resolved <= 2021-09-09 AND project = CB ORDER BY created DESC
• closed >= 2021-09-01 AND closed <= 2021-09-09 AND project = CB ORDER BY created DESC
• done >= 2021-09-01 AND done <= 2021-09-09 AND project = CB ORDER BY created DESC
• resolutiondate >= -7d
• resolved >= -7d
• status changed to Closed after -30d
• resolutiondate >= -1w AND project = CB

Thank you in advance for the help.

[Charalampos Dimitriadis]

You can handle the "Close" like the example below:

status changed to Closed after 2021-08-31 AND status changed to Closed before 2021-09-10

Source: @Willy Wijaya   https://community.atlassian.com/t5/Jira-questions/JQL-for-closed-date-vs-created-date/qaq-p/595575

[Dennis Christilaw]

This is what worked for me, edit as needed:

---

project = {{PORJECT_ID}} AND issuetype = "{{ISSUE_TYPE}}" AND status in (Closed, Rejected, "Rolled Back") AND status changed BEFORE 30d

---

This is showing me the tickets that have been closed in the last 30 days.

[Dennis Christilaw]

Found an issue with the JQL I posted above, this one, however, does work!!

---

project = {{PROJECT_ID}} AND issuetype = {{ISSUE_TYPE}} AND status in (Closed, Rejected, "Rolled Back") AND updated >= startOfDay(-30d)

---

Edit as needed.

Sorry about that, it took me a while (and turning my brain back on) to see that the old query is was borked.

[Nic Brough -Adaptavist-]

So in the first three, you are using date comparisons correctly in theory at least.

Taking just one of the clauses as an example to explain:

closed <= 2021-09-09

in human speak says "the date held in the field called closed is less than or equal to 9th September 2021".  That's a perfectly good question (and to clarify "is less than", that comes out as "before" when talking about dates, because behind the scenes the dates are actually "number of seconds elapsed since 1st Jan 1970", so the larger the number, the later the date)

However, "closed" is not a field in Jira, unless you've added a custom field for it.  I guess that you mean "date/time that an issue transitioned from a status into another that we consider closed", and it's not unusual to see people add custom fields to do this and then have a post-function set the data to "now" when the issue is closed.

But I suspect you've not done that yet!

On the other four, those will work as you expect, so I'm a bit stuck on what you need help with!

[Logan Mulderrig]

status changed to ("UAT COMPLETE", "ARCHIVED", "DONE", "CLOSED") AFTER "2023-12-29" BEFORE "2024-01-23"