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 !!!!
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 ....???
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.