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,361,502
Community Members
 
Community Events
168
Community Groups

Time in Status - Script Runner - custom scripted field - Reset on status change

Edited

The following code and variations has been circulating around on how to calculate a time in the template "duration" format for an issue. I have the code working but I believe it is setup to calculate a cumulative total of any time the issue has been in a status during it's lifecycle.

I'm attempting to create a version of this code that will only show the current instance of being this status (any status). So for instance:

  • Issue is created ->
  • Open (returns time in this instance of Open) ->
  • In Progress (returns time in this instance of In Progress) ->
  • Open (returns time in this instance of Open not adding the time from any previous instance)
  • In Progress (returns time in this instance of In Progress not adding the time from any previous instance)

Here is the code being utilized:

import com.atlassian.jira.component.ComponentAccessor

def changeHistoryManager = ComponentAccessor.changeHistoryManager
def currentStatusName = issue?.status?.name

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

def timeDiff = System.currentTimeMillis() - item.created.getTime()
if (item.fromString == currentStatusName) {
rt << -timeDiff
}
if (item.toString == currentStatusName){
rt << timeDiff
}
}
def total = rt.sum() as Long
return (total / 1000) as long ?: 0L

 I would like this data to retain the duration template if at all possible.

My thought is I need to get the last status change time here somehow, and eliminate the second if statement?

Thank you in advance!

1 answer

1 accepted

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Online AMA this week: Your project management questions answered by Jira Design Lead James Rotanson

We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...

208 views 1 6
Read article

Atlassian Community Events