Why "Extract time in status" with Adaptavist not works?

Alex_2nfdtf

Hi all! i am trying to run the code from the link

 https://library.adaptavist.com/entity/count-the-time-an-issue-was-in-a-particular-status 

But I am getting  time "0"

Ram Kumar Aravindakshan _Adaptavist_

Hi @Alex

I've tested the code in my environment and do not seem to be encountering any issues. I can get the expected result, as shown in the image below:-

I've used the same code to test, with a minor modification to the Issue Type as shown below:-

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.history.ChangeItemBean

// Status to be counted
final statusName = 'In Progress'
def changeHistoryManager = ComponentAccessor.changeHistoryManager
def totalStatusTime = [0L]

// Every status change is checked
def changeItems = changeHistoryManager.getChangeItemsForField(issue, 'status')
changeItems.reverse().each { ChangeItemBean item ->
def timeDiff = System.currentTimeMillis() - item.created.time

// Subtract time if the "from" status is equal to the status to be checked and from and to statuses are different.
// This allows to count the time the issue is in the state for the first time
if (item.fromString == statusName && item.fromString != item.toString) {
 totalStatusTime << -timeDiff

}

// Add time if the "to" status is equal to the status to be checked
if (item.toString == statusName) {
 totalStatusTime << timeDiff

 }
}

def total = totalStatusTime.sum() as Long

// Every time (added or subtracted) is summed and divided by 1000 to get seconds
(total / 1000) as long ?: 0L

Could you please provide a screenshot of the issue history as shown below:-

 

Thank you and Kind regards,

Ram