JQL query for how many resolved stories last 2 weeks

[Rupa Sengupta]

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)

[Rupa Sengupta]

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

[Rudy Holtkamp]

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]

Unfortunately the above is still not returning any results ! 

project = "xyz" AND issuetype = Story AND status = Resolved AND resolved >= "2023-05-09" AND resolved <= "2023-05-23"

But this one is bringing up bunch of stories so there is definitely work that was completed in the last few weeks ! 

project = EIF and status='resolved' and status changed to Resolved after -20d order by updated desc  

Maybe resolved is not the right one to filter on .. it seems to be empty. We have very old tickets in the system so we can't really filter using created date.

Thanks !

[Mayur Jadhav]

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.

[Mayur Jadhav]

Hi @Rupa Sengupta ,

Welcome to the Atlassian Community!!

You can try the following JQL and let me know the result.

project = XYZ AND issuetype = Story AND resolved >= 2023-05-9 AND resolved <= 2023-05-23

Regards,
Mayur