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 tickets closed within a time range

Dora Skorcheva

Hi,

I would like to see all bugs that are closed (with status 'Closed') for a specific time range.

So far I have come up with sth like, but this doesn't suit me.

project = "XYZ AND issuetype = bug AND status changed to closed AND updatedDate < "2015/08/01 00:00" AND updatedDate > "2016/09/15 00:00"

Thank you,

BR
Dora

Accepted answers

Alex Christensen

In your current query, I think you have the date searching operators switched. I think you should be using this instead:

project = "XYZ AND issuetype = bug AND status changed to closed AND updatedDate > "2015/08/01 00:00" AND updatedDate < "2016/09/15 00:00"

Basically, you were trying to search for issues that have an updated date that is both before 1 August 2015 and after 15 September 2016, which is impossible to fulfill.

In your workflow, do you set a Resolution when closing the bug? Whenever you set a Resolution for issue, JIRA also sets a Resolution Date value. You can use this Resolution Date value in your JQL query. Based on your query about, it would look something like this:

project = XYZ AND issuetype = bug AND resolved >= 2015-08-01 AND resolved <= 2016-09-15

This is a much simpler query to use, in my opinion.

Petter Gonçalves

Hello Everyone,

Several teams have interacted In this thread for the past few years, so here is an updated answer for everyone interested in this matter:

Today we’ve two ways to return issues that were closed in a specific time range using the advanced search (JQL) in both Jira Cloud and Server:

Using Dynamic date & time. In the example below, I’ll return all the issues changed to the ”Closed” status between five and two weeks before my current time:

status changed to closed after -5w before -2w
Using Static date & time. In the example below, I’ll return all the issues changed to the ”Closed” status between “08/01/2020 00:00” and “09/15/2020 00:00”:

status changed to closed after "2020/08/01 00:00" before "2020/09/15 00:00”

You can check the documentation below for more details about the functions and operators used in the Advanced queries:

What is advanced searching in Jira Cloud?

Thanks!

All comments

Alex Christensen

In your current query, I think you have the date searching operators switched. I think you should be using this instead:

project = "XYZ AND issuetype = bug AND status changed to closed AND updatedDate > "2015/08/01 00:00" AND updatedDate < "2016/09/15 00:00"

Basically, you were trying to search for issues that have an updated date that is both before 1 August 2015 and after 15 September 2016, which is impossible to fulfill.

project = XYZ AND issuetype = bug AND resolved >= 2015-08-01 AND resolved <= 2016-09-15

This is a much simpler query to use, in my opinion.

Błażej O_

Just try:

project = XYZ AND issuetype = bug AND status changed to closed BEFORE "2016/09/15" AFTER "2015/08/01 00:00"

or simply:

project = XYZ AND issuetype = bug AND status changed to closed DURING ("2015/08/01 00:00","2016/09/15")

Misael Rodriguez

any way to have it run by the last 4 weeks? (without having to insert static dates)

Błażej O_

Sure, just use interval notation, or some date functions.

Following query will show you all bugs that were closed between 5 weeks ago (-5w) and 1 week ago (-1w).

project = XYZ AND issuetype = bug AND status changed to closed BEFORE -1w AFTER -5w

You can also use date functions. Following query will always display bugs closed during last month:

project = XYZ AND issuetype = bug AND status changed to closed AFTER startOfMonth(-1) BEFORE startOfMonth()

If you want to get issues changed in last 4 weeks just use an "AFTER" clause with -4w value.

James_McManamey

We've written up a post on how you can find yesterday's completed issues in Jira.

https://stratejos.ai/blog/find-jira-issues-completed-yesterday-using-jql/

Also how you can filter the results by the people who completed them. Great for product managers and team leads.

Stratejos lets you run JQL from Slack and also set up daily custom messages with the results of any JQL.

Petter Gonçalves

Hello Everyone,

Several teams have interacted In this thread for the past few years, so here is an updated answer for everyone interested in this matter:

Today we’ve two ways to return issues that were closed in a specific time range using the advanced search (JQL) in both Jira Cloud and Server:

Using Dynamic date & time. In the example below, I’ll return all the issues changed to the ”Closed” status between five and two weeks before my current time:

status changed to closed after -5w before -2w
Using Static date & time. In the example below, I’ll return all the issues changed to the ”Closed” status between “08/01/2020 00:00” and “09/15/2020 00:00”:

status changed to closed after "2020/08/01 00:00" before "2020/09/15 00:00”

You can check the documentation below for more details about the functions and operators used in the Advanced queries:

What is advanced searching in Jira Cloud?

Thanks!

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-software