Trying to assist a team tracking their issue under under Epics as "Action Items Completed On Time." I'd like to be able to compare the Due Date field with the date the ticket Status changed to Done.
I was thinking if using a JQL such as (resolutiondate <= "Due Date") but there seems to be limited to making another comparison to another function or fixed date.
Is there a way to query this with JIRA out-of-box?
Hello @Henry Chad Apale
If you haven't found a JQL solution yet, as an alternative, you can try Time in Status for Jira Cloud. It generates a Status Entrance Date report that shows the date an issue has entered each of the statuses.
So you can compare the Due Date field with the date the ticket Status changed to Done easily.
This add-on is developed by my SaaSJet team and is free for using up to 10 users. So let me know if you have any additional questions.
Hope it helps.
You may want to consider some reporting plugins as well such as eazybi.
This is an example: https://community.eazybi.com/t/show-jiras-that-have-passed-the-due-date-overdue-items/439
There are a bunch of other reporting plugins that may have a similar functionality such as structure which has formulas.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Currently, it can be achieved via add-ons
Scriptrunner
issueFunction in dateCompare("", "resolutionDate > dueDate")
Ref here
In Jira, there is a support request on this
https://jira.atlassian.com/browse/JRACLOUD-20727
Thanks,
Pramodh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jira Product Discovery Premium is now available! Get more visibility, control, and support to build products at scale.
Learn moreOnline forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.