Days the ticket is in current status

Hello,

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.

 

Regards,

Santosh

2 answers

0 vote

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

No.

We don't have any similar add-ons.

Regards 

Santosh 

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? 


Thanks
Ankit

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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,296 views 14 20
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot