JIRA - Show tickets Resolved x days after Created.

[Bartek_Durden]

Hi All,

I'm looking for a JQL that could allow me to show tickets with variuos periods of time, <7 days, 7-14 days, 14-30 days, >30 days, and the criteria is days passed between Created and Resolved.

I was looking for something like this but only find JQLs that show tickets closed eg. 7 days ago from today.

Could you help me with this one?

Thanks!

[Leo · Accepted solution]

Hi @Bartek_Durden,

I believe this can be achieved with scriptrunner plugin

below query will help you to find all tickets that are closed exactly after 5th day from creation

issueFunction in dateCompare("","created > resolved-5d") AND issueFunction in dateCompare("","created < resolved-4d") 

 likewise you can re-frame your queries to achieve your requirement

Hope this helps

BR,

Leo

[Bartek_Durden]

Thank you @Leo, it is exactly what I wanted :)