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

[Trott Mbanjwa]

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"

[Marco Brundel]

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]

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]

Hi MArco,

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

[Marco Brundel]

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