It's not the same without you
Join the community to find out what other Atlassian users are discussing, debating and creating.
is it possible to search issues which were overdued? I mean all those issues which were changed to Closed status after their Duedate?
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
actually you should try just RESOLUTIONDATE>duedate.
thanks a lot!
Still have a question?
Get fast answers from people who know.
Hey Atlassian community, I help lead engineering at Sentry, an open-source error-tracking and monitoring tool that integrates with Jira. We started using Jira Software Cloud internally last year, a...
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs