Scripted fields calculation : No of Days calculation - issue navigator

Rajesh Asana

hi,

 

I was trying to calculate cycle time (time since) of issue in the current state using the below code.

It is not giving consistent results.

Don't know why

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

def changeHistoryManager = ComponentAccessor.getChangeHistoryManager()
def currentTime = System.currentTimeMillis()
def stateTime = 0

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

if (items) {
stateTime = items.first().created.time
}
else {
stateTime = issue.getCreated().time
}

def stateCycleTime = (currentTime - stateTime) / (1000*60*60*24)

return (stateCycleTime as Double).round(2) ;

 

 

Can any one help in understanding the problem and a good fix

 

Mark Kern [SaaSJet]

Hi @Rajesh Asana
You can get a good fix for this problem by using additional plugins instead of doing it manually with code.

For instance, you can use Time in Status for Jira Cloud by SaaSJet (you can get it from Atlassian Marketplace). This add-on helps you to easily and automatically calculate the time of issue in the current state.

Also, you can try Time Between Statuses for calculation status to status time. This app help you to get the Cycle and Lead Time of your Jira issues

Data from two these add-ons are available for export as XLSX or CSV file.

Hope this helps!