how to get the time spent from Assigned to In Progress in jira?

fabby

my jira version is 4.4.1

my jira workflow is

i tried to use Scripted Field to get the time spent from Assigned to In Progres?

i can get the time Start Progress(4) (the time change Assigned status to In Progress Status) by

changeHistoryManager.getChangeItemsForField (issue, "status").reverse().each {ChangeItemBean item ->
 item.fromString=="Assigned" && item.toString=="In Progress"
}

my problem is how can i get the Assign time (some action like Assign761,Assign751,or Assign 741 whose destination step is Assigned).i.e. Start Progress(4) 's previous Action time

any one can give some ideas?

fabby

i have fix it myself.

import com.atlassian.core.util.DateUtils
import com.atlassian.jira.ComponentManager
import com.atlassian.jira.issue.history.ChangeItemBean
import com.atlassian.jira.issue.Issue 
  
def componentManager = ComponentManager.getInstance()
def changeHistoryManager = componentManager.getChangeHistoryManager()

log.warn("+++++++++++++++++++++++")

def getTimeSpent={  //define a closure to get transfered timeSpent
    if(it){
        return it
    }else{ //negative value or less than one minute
        return "<1m"
    }
}

def createTime=issue.getCreated().getTime() // getTime() tranfer to milliseconds
log.warn("create time:"+issue.getCreated().toString()+"to millisecond:"+issue.getCreated().getTime())

def firstAssign=changeHistoryManager.getChangeItemsForField(issue, "status").find{
it.fromString=="Open" && it.toString=="Assigned"
}?.getCreated()
log.warn("firstAssign:"+firstAssign)

def firstStart=changeHistoryManager.getChangeItemsForField(issue, "status").find{
it.fromString=="Assigned" && it.toString=="In Progress"
}?.getCreated()
log.warn("firstStart:"+firstStart)

if(firstAssign){ //has initially Assign
    if(firstStart){ //has execute Start Progress
        def Duration_A=[0] //Assigned->In Progress
        def Duration_R=[0] //Reopened->In Progress
        
        def items = [["","",""]]
        changeHistoryManager.getChangeItemsForField (issue, "status").each {
            if (it.toString == "Assigned" || (it.fromString == "Assigned" && it.toString == "In Progress")) { //filter specified status
                items << [it.fromString,it.toString,it.created]  
            }
        }
        items=items.drop(1)
        //log.warn("items:"+items)
        while(!(items.last().getAt(0)=="Assigned" && items.last().getAt(1)=="In Progress")){
            items.pop()
        }
        log.warn("items:"+items)
        for(int i=0;i<items.size();i++){
            if(items.getAt(i).getAt(0)=="Assigned" && items.getAt(i).getAt(1)=="In Progress"){ 
                Duration_A << items.getAt(i).getAt(2).getTime()
            }else if(items.getAt(i+1).getAt(0)=="Assigned" && items.getAt(i+1).getAt(1)=="In Progress"){
                Duration_A << -items.getAt(i).getAt(2).getTime()
            }
        }
        Duration_A=DateUtils.getDurationString(Math.round(Duration_A.sum()/1000))
        timeSpent_A=getTimeSpent(Duration_A)
    }else  //return the time from Assign to now
    {
        def Duration = System.currentTimeMillis() - firstAssign.getTime()
        def timeSpent=DateUtils.getDurationString(Math.round(Duration/1000))
        timeSpent=getTimeSpent(timeSpent)
    }
}else{ //there aren't workflow transitions executed yet.
    return "has not Assigned yet"
}