JQL for bugs that took more than 15 days to be closed

[Rodrigo Cunha]

I want to get a list of bugs that took more than 15 days to be closed. How can I get this with JQL?

It should be something like this:

resolvedDate > createdDate + 15d

[Rodrigo Cunha · Accepted solution]

Looks like my company has installed some kind of library on our JIRA and there is a function that works for my case:

issueFunction in dateCompare("", "resolutionDate > dueDate")

https://scriptrunner.adaptavist.com/5.5.8/jira/jql-functions.html#_datecompare

[Zoryana Bohutska _SaaSJet_]

Hi @Rodrigo Cunha 

Additionally, you can consider Time in status for Jira Cloud app. It can automatically get time in each status, including Done. So in this case you just need to export time in status report and sort time data. 

Regards

[Mehmet A _Bloompeak_]

Hi @Rodrigo Cunha ,

The feature you are looking for is not a built-in functionality in Jira. Our team at Bloompeak developed Status Time app for this exact need. It provides status time report of issues. You can group statuses and get the resolution time report. You can export the report as CSV and using Excel you can filter the ones which took more than 15 days.

Here is the online demo link, you can see it in action and try. Hope it helps.

[Mohamed Benziane]

Hi @Rodrigo Cunha 

You can't compare two field in JQL, but you can try work with date range like this

Created >= (01/10/2010) and resolved >=(startOfDay())

Foe the created date you can use function like startofweek, startofmonth if you want.

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-functions-reference-939938746.html