JQL Query to Find Issues Resolved On or Before Due Date

[shalini mahale]

How can I get the number of issues resolved within 14 days of created date from a backlog

[Sreenivasaraju P]

Hi @shalini mahale,

I don't think , you can achieve this out of the box. You can try third party plug in like script runner.

https://scriptrunner.adaptavist.com/5.0.6/jira/jql-functions.html

[Carlos Garcia Navarro]

Hi Shalini,

It seems that there is a current request to add ability to compare date fields using JQL but it's not implemented:

https://jira.atlassian.com/browse/JRASERVER-20727

https://jira.atlassian.com/browse/JRACLOUD-20727

So it's not natively supported in JIRA but you may be able to use plugins to perform this comparison as described in this other thread:

https://community.atlassian.com/t5/Jira-questions/JQL-Query-to-Find-Issues-Resolved-On-or-Before-Due-Date/qaq-p/345820

Hope it helps (I'd suggest to vote for the issues mentioned above if you're interested in the feature :-)),

Carlos