Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Find all tickets where the time between two statuses exceeds a certain value

Our bug tickets start out in the Status "New". At some point they are confirmed and move to the Status "Confirmed". Eventually the bug fix is completed and the ticket moved to the status "Done". 
I want to find all tickets that have spent more than a certain amount of days between the status "Confirmed" and "Done". The clock should start as soon as a ticket is moved to "Confirmed".


Is this possible to do with JQL?

3 answers

2 accepted

1 vote
Answer accepted
Derek Fields Community Leader Sep 15, 2020

This requires a plugin. There are several in the marketplace. Search on "Time in Status"

Yes, it is true

@Roland Weilbacher Lools like app Time between statuses can help you. This add-on calculates status to status time and lets set time limits. So you will be able to monitor time data and overdue issues on time between statuses report.  2020-02-27_13-25-13.png

Like Roland Weilbacher likes this

Hi @Roland Weilbacher ,

You can use Enhancer Plugin for Jira for this requirement.

It has custom fields called Time between and Time in status custon fields that measures the time spent between two statuses/ events. You can also see drill down information based on assignee and you can search issues against Time between field in the issue navigator.


Let me know if you have any questions.



Hi @Roland Weilbacher ,

As a free solution, you can try Status Time Free. It a limited but free version of Status Time app. Here is the online demo link of unlimited version, you can see it in action and try. Hope it helps.

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you