Querrying issues resolved for the past days not working on JIRA v8.11.0 using resolutiondate

Trott Mbanjwa October 12, 2020

Hi Team

Im using JIRA for reporting and want to report on all issues resolved the past 7 days as an example. I have tried the below filters but i do not get a response:

 

project = "VFS DevOps" AND component = DevSupport AND resolutiondate >= "2020-09-01" and resolutiondate <= "2020-09-30"

OR

project = "VFS DevOps" AND component = DevSupport AND resolutiondate <= startOfDay(-70)

OR

project = "VFS DevOps" AND component = DevSupport AND resolutiondate <= "-7d"

1 answer

0 votes
Marco Brundel
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 12, 2020

Hi @Trott Mbanjwa ,

 

With

resolutiondate >= -7d

Or

resolved >= -7d

In a JQL filter on my Jira Cloud a get the issues that are resolved in the last 7 days.

 

When you try one part of the JQL (for example project = "VFS DevOps" AND component = DevSupport) , do you get issues?

And is field Resolution filled in in the issues?

The resolution date is set when the field “resolution” is filled.

Regards, Marco

Trott Mbanjwa October 12, 2020

Hi Marco,

I have no issues running this filter "project = "VFS DevOps" AND component = DevSupport"

How do i check if the resolution is filled in?

Trott Mbanjwa October 12, 2020

Hi MArco,

On my view, the resolution date does not appear. See attached my workflow

Marco Brundel
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 12, 2020

Hoi,

If you have no issues running this filter "project = "VFS DevOps" AND component = DevSupport", then you will also not find issues when you extend this filter with "AND resolutiondate >= -7d".

The field Resolution is a field what you can find in a issue screen. Because the resolution date is set when the field “resolution” is filled the advice is to make a postfunction in a workflow transition to a status in the DONE category that sets the resolution. Or that there is a validator on a workflow transition to a status in the DONE category that Resolution is required.

 

regards, Marco

Suggest an answer

Log in or Sign up to answer