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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

172 views 1 10
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