Get product advice from experts

Ask a question →

Join a community group

Find a group →

Advance your career with learning paths

Take a free class →

Earn badges and rewards

Connect and share ideas at events

See the calendar →

Community
Products
Jira
Questions
How to select issues overdue in table jiraissue?

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

1 answer

0 votes

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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.

Comment

Like

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS

Community showcase