JQL query for how many resolved stories last 2 weeks

Question

Hello all

I am trying to include a report within Confluence and need help to input a JQL query which will show all the Stories that were resolved within specific date range

So far I have tried

project = "project name" AND resolved is not EMPTY AND resolved > 2023-01-01 AND resolved < 2023-05-01

But it's not spitting out any results (stories resolved between 9th May 2023 to 23rd May 2023)

Mayur Jadhav_30osel · Answer

it is due to don't have resolution yet. As @Rudy Holtkamp mentioned use post function or automation rule to set the resolution. Or you can also add the screen and resolution field while transitioning an issue to the done status.

Rudy Holtkamp · Answer

Best practice: You should add a post-function to the transitions that go to a 'resolved' issue. This post function should fill in the resolution field.

Rupa Sengupta · Answer

All of the fields related to Resolved seems to be empty. I can't seem to find any other field we could use to filter out tickets resolved between certain dates