I would like to be able to see all DONE issues that have missed their due date.
In principle the query would show all issues who's completed / resolved date is later than the dude date.
Any ideas on the JQL for this?
You cannot with the built in functionality. If you are able to install or have ScriptRunner, then you can use their expression function to do the query.
https://jamieechlin.atlassian.net/wiki/spaces/GRV/pages/33030163/Scripted+JQL+Functions#ScriptedJQLFunctions-expression%28Subquery%2Cexpression
Alternately, you can export all Done issues into excel and filter from there.
Customize a field to get the date of the problem resolution and then compare it with the duedate.
like:
resolution is not EMPTY and duedate < closedate
Ollie is right, you should make such a comparison if you want to achieve with Jira out-of-the-box features.
However, you can have more if you use apps like Time to SLA. You can define SLA in which duedate field may be the negotiation date. Also, you can have notifications, JQL functions, reports, gadgets, ...
So, if you only need basic comparison, you can have a solution as Ollie offered. But if you need more, you should try add-ons like Time to SLA, SLA Powerbox, SLA Timer, ..
From my understanding, comparison of two fields isn't supported with the out of the box functionality.
Thanks @Randy. It would seem an export to excel is the most logical for now.
It looks like you're new here. Sign in or register to get started.
