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

Days the ticket is in current status


I need  to Create field that will calculate the numbers of days that a CR has been in the current status.

For example. we move the status of the CR to "Pending". the field : Days since Status change - would count the number of days until the CR is changed to the next status. once the CR is moved from Pending to next status the count would reset and count until next change of status.




2 answers

0 votes

You're going to need some coding for that.  Have you got Script Runner or one of the other scripting add-ons?


We don't have any similar add-ons.



Ok. There are several approaches to this: * create a date/time field (only on the view screen) and have post-functions stick "current date" into it on every transition * Do much the same in a listener * Write a calculated field that works out the date/time of the last status change from the issue history You'll notice there's a flaw with those - they all give the user the date/time of the last change, not "time since". The reason for that is that the date/time is a static value. The time elapsed is dynamic - it's a new value every time you look at the issue. JIRA doesn't really have any way to do that. If you definitely need a dynamic value, you'll need something a bit more clever - you'll still need to code for one of the tricks above, but then you'll need more code to display it as a dynamic (now - last date change) and if you do it the way I think you'd need to (javascript), you won't get it coming out as an elapsed time on reports or downloads either.

Hi Nic, 


I have scriptrunner and am looking for a same field which would determine the time in status. can you help me with some code on that? 


Nic - I know this is very old thread but still looking for something similar.

I need a field which populates current status cumulative duration. Currently I have placed the script in post-function on transition but it updates only on transition, but it can't tell the current duration in the current status, any pointers will be helpful.

Hi @santosh srirangam, you might want to check out our Days Elapsed Plugin to see if it fits your requirements.

The custom field can calculate the number of working days and display a traffic light to indicate the SLA. The counting is triggered on/off by firing post functions. No coding is required.

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