How to select issues overdue in table jiraissue?

[SungLB]

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 !!!!

[Nic Brough -Adaptavist-]

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

[SungLB]

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