Groovy: show time this issue In-Progress status (Not Total)

Serj Shcherbakov
Contributor
April 4, 2016

Hi!
How i can show up days count of last transition.
I dont need calculate total, this value should be refreshable and setted per new transition.

import com.atlassian.core.util.DateUtils
import com.atlassian.jira.ComponentManager
import com.atlassian.jira.issue.history.ChangeItemBean

def componentManager = ComponentManager.getInstance()
def changeHistoryManager = componentManager.getChangeHistoryManager()

def inProgressName = "In Progress"

def rt = [0]
changeHistoryManager.getChangeItemsForField (issue, "status").reverse().each {ChangeItemBean item ->

    def timeDiff = System.currentTimeMillis() - item.created.getTime()
    if (item.fromString == inProgressName) {
        rt << -timeDiff
    }
    if (item.toString == inProgressName){
        rt << timeDiff
    }
}

// NOTE: doesn't show anything if less than 60 seconds
DateUtils.getDurationString(Math.round(rt.sum() / 1000))


Can some one help me?

8 answers

1 accepted

3 votes
Answer accepted
JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 5, 2016

OK:

import com.atlassian.jira.component.ComponentAccessor

def changeHistoryManager = ComponentAccessor.getChangeHistoryManager()
def items = changeHistoryManager.getChangeItemsForField (issue, "status").reverse()

if (items) {
    return ((new Date().time - items.first().created.time) / 1000) as Long
}
else {
    return ((new Date().time - issue.getCreated().time) / 1000) as Long
}

Searcher: Duration

Custom template:

#if ($value)
	$jiraDurationUtils.getFormattedDuration($value)
#end
Рогов Денис
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 7, 2023

You are the best, thanks! This working for me =) 

arno
Contributor
August 21, 2023

Hi @JamieA 

I want to calculate the time from create to solve the issue, and how can I get this? The value I hope to get is: the time point when the issue is closed minus the time point when the issue is created, and the corresponding value. I wonder if you can understand my demand

Ivan Shtanichev
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 21, 2024

Thanks @JamieA , great solution!

I found a small way to enhance this by changing to Custom template:

#if ($value)
	&#1F553; $DateUtils.getDurationString($value)
#end

Which adds a leading clock face symbol and displays duration in the shortest format..

🕓 1w 18h 10m

Hope this is useful to others.

0 votes
Serj Shcherbakov
Contributor
April 11, 2016

@Jamie Echlin [Adaptavist] hi!

I solve this via:

image2016-4-11 17:56:36.png 

 

And Searcher: 

image2016-4-11 17:56:58.png 

Can you help me a little bit?
Now current field show me a seconds, 

how i can convert it to time? (minutes/hours/days?)

JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 11, 2016

getDurationString should return you a properly formatted duration... 

Best thing is to return a Long then use the template as I originally recommended. I don't think the search will work though. Try all this with no searcher.

Serj Shcherbakov
Contributor
April 12, 2016

 I'll tried this all with searcher "None" and with sting/long combinations:

    $jiraDurationUtils.getDurationString($value) 

     $jiraDurationUtils.getFormattedDuration($value)

    $jiraDurationUtils.getDaysDurationFormatter($value)

    $jiraDurationUtils.getHoursDurationFormatter($value)

    $jiraDurationUtils.getPrettyDurationFormatter($value)

    $jiraDurationUtils.getShortFormattedDuration($value)

It doesnt worked in JIRA 6.4.5 and Script Runner v 3.1.4

Nevertheless thank you @Jamie Echlin [Adaptavist].

0 votes
Serj Shcherbakov
Contributor
April 6, 2016

Hi!

something goes wrong...

 image2016-4-7 10:24:50.png

Serj Shcherbakov
Contributor
April 6, 2016

Untitledasda.jpg

JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 7, 2016

Change the searcher for the field to Duration, as I said in my answer. If you don't see Duration you might be using an older version, if so which one?

Serj Shcherbakov
Contributor
April 7, 2016

Current versiob is: v 3.1.4
JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 7, 2016

Set the searcher for the field to None then, but it's best if you can upgrade so you can using the duration indexer. You didn't answer the question about whether it was there by the way.

Serj Shcherbakov
Contributor
April 11, 2016

Hi @Jamie Echlin [Adaptavist] 
I did what you recommended, so i can see now is that it is:$jiraDurationUtils.getFormattedDuration($value) 

Untitled111.jpg 

0 votes
Serj Shcherbakov
Contributor
April 5, 2016

@Jamie Echlin [Adaptavist] Hi!
Please, clarify.

0 votes
Serj Shcherbakov
Contributor
April 5, 2016

Jamie, yes.
Could you add more details here, sorry but i dont know how realise it via groovy code, can you advise please?

0 votes
JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 5, 2016

You just want the time in the current status? Then you just need to subtract the first change item returned from the current date.

0 votes
Serj Shcherbakov
Contributor
April 4, 2016

Hi Jamie,
Yes, you right.
This code show me total days. But i'm needed to show up days according each transition to this status (not total).

For example (how this should work):
I changed my status from Open to In-Progress yesterday, and now i see 1 day,
I changed it status to on-hold, then i am again changed it to in-progress and now i see 1 min,

do you understand?

0 votes
JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 4, 2016

Can you elaborate on "How i can show up days count of last transition". Why did you post that code, is that what you have tried?

Suggest an answer

Log in or Sign up to answer