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; } } }

How to select issues overdue in table jiraissue?

hi All,

I have jira license with unlimited users.

I want to have some reports independently with reports off jira.

I add a new link "reports " at top bar jira:

Ex: dashboard, projects, issues, reports, administrators

I am coding some jsp file for some reports...

I have a question:

How to select Issues Overdue in table "jiraissue"?

Thanks you !!!!

Accepted answers

All comments

Nic Brough -Adaptavist-

Use "duedate < now()" as part of the JQL query you are building.

hi, thanks Nic Brough.

But, I want to know "how many issues overdue at specific time"?

ex: how many issues overdue from "01/01/2011" to "30/01/2011"?

ex: select count(id) from jiraissue where duedate between "01/01/2011" and "30/01/2011" and resolution is null ....???

Welcome!

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

Quick Links

Find more posts tagged with

jira

database

due-date