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? 


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 showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,949 views 19 22
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you