What is missing from this Groovy script when creating a script to find time between/held in status?

Matthew Nico

I am testing and trying to query to use Scriptrunner to find issues and time frames in between different status. I feel like I am close, but I'm getting null value. Would I have to define dates that it was in one status totaled into another? What am I missing here? Any tips or help is appreciated!  

 

import com.atlassian.jira.issue.Issue

import static java.lang.Math.*

import com.atlassian.jira.util.JiraKeyUtils

import java.lang.String

def startTime = System.currentTimeMillis();

def query = JiraKeyUtils.getIssueKeysFromString("project = DAFCEE AND status = Initial Customer Outreach")

def totalIssues = 0;

def totalTime = 0;

for ( issue in query )

{totalIssues += 1;

    def workflowAction = issue.getActions();

    def timeSpent = workflowAction.getTimeSpent();

    totalTime += timeSpent;

    }

def endTime = System.currentTimeMillis();

def totalTimeinMinutes = totalTime /60000;

def totalTimeInHours = totalTimeinMinutes / 60;

println("It takes " + totalTimeInHours + " hours and " + totalTimeinMinutes / 60 + " minutes for " + totalIssues + " issues with the project DAFCEE to move from the status as Initial Customer Outreach to In Evaluation in a workflow.");

println("Time Elapsed: " + (endTime - startTime) + "ms");

Tuncay Senturk _Snapbytes_

Hi @Matthew Nico 

I don't think you're that close. If you want to calculate time spent in each status for an issue you have to use ChangeHistoryManager to retrieve all transitions and then calculate the time passed accordingly.

I am sharing a sample code which collects all durations in statuses in a map statusTimes. In this map, the keys are the status names and the values are the start/end dates.

You can calculate times per issue, or you can sum them and keep the total values among the JQL.

I hope it helps

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.status.Status
import com.atlassian.jira.issue.changehistory.ChangeHistoryManager
import java.util.Date

def changeHistoryManager = ComponentAccessor.getChangeHistoryManager()

def issue = // assuming you run below code for each issue

def statusTimes = [:]

def changeHistoryManager = changeHistoryManager.getChangeHistoriesForUser(issue, null)
changeHistoryManager.each { change ->
   def fromStatus = change.getFromStatus()
   def toStatus = change.getToStatus()
   def date = change.getCreated()
   if (!statusTimes[fromStatus.name]) {
      statusTimes[fromStatus.name] = [start: date, end: null]
   } else {
      statusTimes[fromStatus.name].end = date
   }
   if (!statusTimes[toStatus.name]) {
      statusTimes[toStatus.name] = [start: date, end: null]
   }
}

for (def status : statusTimes.keySet()) {
   def statusDuration = statusTimes[status]
   def start = statusDuration.start
   def end = statusDuration.end ?: new Date()
   def duration = end.getTime() - start.getTime()
   log.info("Time spent in status '$status': ${duration/1000} seconds")
}