How to detect the issues that stay on one status too long time?

[sh zh]

Hi,

How can I get the issues, that stay on one specified status too long time.

Like Stay on "Open" status over 7 days.

Or Stay on "Review" status over 2 days.

Thanks,

Shaohua

[Udo Brand · Accepted solution]

with JQL you can use

status = open and status changed to open before -7d

maybe you would have to exclude issues that were in the meantime reopened

..and not status changed from resolved to open after -7d

or something like this

Hope this helps

[Alexey_Rjeutski__Polontech_]

For complex workflows that will require quite a big set of excludions. NOT status CHANGED is better solution - as for https://jira.atlassian.com/browse/JRA-26469CHANGED works with NOT

[Andrew L]

Hi,

How do i query for "status has NOT changed for exactly X days"?

Thanks

--Andrew

[Alexey_Rjeutski__Polontech_]

Try JQL like:

status = "Open" and NOT status CHANGED AFTER "-7d"

status = "Review" and NOT status CHANGED AFTER "-2d"

[Udo Brand]

as I said "... or something like this "

[Ege Su İnan]

Hi Everyone,

We recently released a plug-in that mesures time between status. I think Time in Status will solve your problem.

Here is the link to discover more about Time in Status.

https://marketplace.atlassian.com/plugins/com.obss.plugin.time-in-status

Thank you for your interest in OBSS Atlassian Platinum Partner 

[Tiago Comasseto]

You may use the Average Time in Status report or Transitions Summary Tab as suggested here.

Cheers