Find issues that have exceeded their due date

[Karl Rohde]

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?

[Tuncay Senturk]

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, ..

[Ollie Guan]

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

[Randy]

From my understanding,  comparison of two fields isn't supported with the out of the box functionality.

[Randy]

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.

[Karl Rohde]

Thanks @Randy. It would seem an export to excel is the most logical for now.