Overdue search

[Rumceisz]

Hi All,

is it possible to search issues which were overdued? I mean all those issues which were changed to Closed status after their Duedate?

Thanks,

Rumi

[Diego Zarpelon · Accepted solution]

Hey Rumceisz

You can use an SQL query on your database to see it. It will look like this:

select * from jiraDB.jiraissue where issuestatus=6 and RESOLUTIONDATE >= duedate;

This will list all overdue issues.

Hope this helps!

[Diego Zarpelon]

actually you should try just RESOLUTIONDATE>duedate.

[Rumceisz]

Hi Diego,

thanks a lot!