Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,369,653
Community Members
 
Community Events
168
Community Groups

How to calculate the number of days the issue is in a particular status?

Hi Team,

I need to calculate the number of days the issue was in particular status. I checked the below link, but it is showing the result in format of weeks, days, minutes..

https://community.atlassian.com/t5/Jira-questions/How-to-show-the-no-of-days-the-issue-is-being-worked-on/qaq-p/1430109

 

I am using Script runner plugin. Could you please help me in getting number of days as a integer value in the field

1 answer

1 accepted

0 votes
Answer accepted

Hi @Suvidhaa Subramani 

 

Please check Script runner library. IMHO this can be helpful - https://library.adaptavist.com/entity/count-the-time-an-issue-was-in-a-particular-status

 

Regards,

Seba

 

Hi @Sebastian Krzewiński 

This code returns the time in Week, days format.

my requirement is to have only number of days.

For example,

If the total time in that particular status is 10 days, then the code is returning 1W 3D

But I am expecting 10 in the field

Could you please help me

@Suvidhaa Subramani as I see script return time in seconds. What I see from your example is that Jira is converting time to this format. Please check type of your field and see this doc how to fix this - https://community.atlassian.com/t5/Jira-Core-Server-questions/Time-Spent-Display-format-change/qaq-p/1302371

 

Regards,

Seba

I changed my duration field to number field and converted the milliseconds answer to days. It worked

Like Sebastian Krzewiński likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events