nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Diego Zarpelon

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 &gt;= duedate;

This will list all overdue issues.

Hope this helps!

All comments

Diego Zarpelon

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 &gt;= 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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira