How do I find issue open for long time?

[Deleted user]

Hello All,

I like to find the age of issue that has been open for long time (max age). Could you please share if you have a report or have ideas?

Thanks

Jaykay

[Earl McCutcheon]

Hello Jaykay,

To get older issues you will first want to identify the open issues, and this can be done with the "not in" operators with something like the following:

status not in (closed,resolved,done)

Can use the JQL functions for "endof" or "startof" interchangeably for an identifier on the time frame ranges using negative values to identify how far back you want to set the query depending on the desired criteria for you definition of a "long time", I'll do the exe queries using the functions for endOfMonth() but the others are:

• endOfDay()
• endOfMonth()
• endOfWeek()
• endOfYear()
• startOfDay()
• startOfMonth()
• startOfWeek()
• startOfYear()

So using these functions you can do something like the following to get all issues created before the end of the month, 6 months ago that are still in a status that is not a closed/completed status:

status not in (closed,resolved,done) AND created >= endOfMonth(-6)

An alternative to this if you want to track issues that have been in a particular status for an extended period of time you can use the "Changed" operator with a "before" modifier and a specific status to do something like the following:

status changed to "Open" before endOfMonth(-6) AND status = "Open"

The above query will give you anything that is still in the open status for greater than the noted timeframe.

Hope this helps get you started, and additional JQL references can be found in the "Advanced searching" documentation, but if you have some additional specifics on the criteria you're looking for let me know and I can help you narrow down the result set.

Regards,
Earl