Extract time in status
10 answers
2 accepted
It's actually a double error.
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.history.ChangeItemBean
import com.atlassian.core.util.DateUtils
def changeHistoryManager = ComponentAccessor.getChangeHistoryManager()
def inProgressName = "Assess 2nd Line"
List<Long> rt = [0L]
def changeItems = changeHistoryManager.getChangeItemsForField(issue, "status")
changeItems.reverse().each {ChangeItemBean item ->
item.toString == inProgressName
def timeDiff = System.currentTimeMillis() - item.created.getTime()
if (item.fromString == inProgressName) {
rt << -timeDiff
}
if (item.toString == inProgressName){
rt << timeDiff
}
}
def total = rt as int []
return DateUtils.getDurationString(Math.round(total.sum() / 1000))
Still errors:
I tried this scripted field as well, and I always get 0 min as the time in status. No errors shown in code:
Hi @Slava Gefen and everyone who is looking for solution 😌
As an alternative, for advanced analysis you can try - Time in Status for Jira (Cloud, Data Center), (developed by SaaSJet) that generates 7 types of status reports including Status Entrance Date report. It shows the date a particular issue has entered each of a status (Resolved or Closed, etc.).
- set date or date ranges you need
- get dates when the issue has entered each of the statuses on the grid.
On the chart, it shows the number of tasks that have entered a status on a certain date - for example, 1 task out of 5 tasks has entered the Progress status for the first time on the 23-rd of May.
Add-on has a 30-day free trial version and free up to 10 users .
Hope it helps 😌
So I am using a longer method for getting time in all statuses, see the example below. I am having 2 issues, one I have resolved by using my own calculations:
- First issue I had was using the DateUtils.getDurationString(total) method, which kept on returning 0m, I used this:
def newRT = rt as long []
rt.clear()
def total = newRT.sum()/ 1000 as longdef seconds = total.intValue()
def iD = (seconds / 85400).round(0)
def days = seconds % 86400
def iH = (days / 3600).round(0)
def hours = days % 3600
def iM = (hours /60).round(0)
def strTimeStr = sName + ": " + iD.toString() + "d " + iH.toString() + "h " + iM.toString() + "m" + " | "
strResult += strTimeStr
- The above solved the output of the time in strings, however with Backlog I have a weird total, I will iclude the screenshot below:
-
- Expected 12s
-
Here is the script below (I am going to add logic to the output to only print d m h if there are values for them):
//Import the relevant libraries
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.history.ChangeItemBean
//Define the variables to be used
def strResult = ""
List<Long> rt = [0L]
List<String> statusName = []
def changeHistoryManager = ComponentAccessor.getChangeHistoryManager()
def changeItems = changeHistoryManager.getChangeItemsForField(issue, "status")
//Validate that there is only one of each change item name
for(item in changeItems){
if(statusName.contains(item.getToString())){
//Do Nothing
} else {
statusName << item.getToString()
}
}
//Get time difference for each status and concatinate onto strResult
for(sName in statusName){
changeItems.reverse().each { ChangeItemBean item ->
if (changeItems.indexOf(sName) == 0){
rt << issue.create.getTime() - item.create.getTime()
} else {
item.fromString == sName
def timeDiff = System.currentTimeMillis() - item.created.getTime()
if (item.fromString == sName) {
rt << -timeDiff
}
if (item.toString == sName) {
rt << timeDiff
}
}
}
//Create the output string
def newRT = rt as long []
rt.clear()
def total = newRT.sum()/ 1000 as long
def seconds = total.intValue()
def iD = (seconds / 85400).round(0)
def days = seconds % 86400
def iH = (days / 3600).round(0)
def hours = days % 3600
def iM = (hours /60).round(0)
def strTimeStr = sName + ": " + iD.toString() + "d " + iH.toString() + "h " + iM.toString() + "m" + " | "
strResult += strTimeStr
}
return strResult
If anyone could provide advice for including something to calculate for the first status of the workflow? I know the majority of our projects use Backlog but there may be a few that use another status in the beginning of the workflow
Thanks in advance
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.