nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to get 'Time In Source Status' like on Transition Tab?

fabby

my jira version is 4.4.1

i want to obtain spent time from Open status to Resolved status,and display the spent time in one custom field.

and find 'Time In Source Status' on Transition Tab is like what i want.

but i don't know how the 'Time In Source Status' comes from ?

Accepted answers

Mizan

Did you try using scripted fields provided by Script runner plugin ? There is a similar script provided in the docs https://studio.plugins.atlassian.com/wiki/display/GRV/Scripted+Fields#ScriptedFields-TotaltimethisissuehasbeenInProgress

You will need to modify it to suit your requirement , you will need to add one field for each status.

All comments

Rahul Aich [Nagra]

We have a plugin vertygoSLA which captures that information. This is a plugin to monitor and track SLA compliance. This is however not a free plugin but you can try it for free for 30 days.

https://confluence.atlassian.com/display/JIRA/JIRA+as+a+Support+System

Rahul

Renjith Pillai

Transition tab comes from JIRA Suite Utilities. What do you mean by 'you want to use post function'?

fabby

i just want to use post function

fabby

i find the "Script Post-Function" ,it has 'Built-in-Scripts' and 'Script file path'.

fabby

hi Renjith

i just want ot retrieve the time spent from Open status to Resolved status. and store the spent time in one custom field.

so i consider using post function to obtain the spent time. and store the value in custom field.

Mizan

You will need to modify it to suit your requirement , you will need to add one field for each status.

fabby

thanks,

i used Scripted Field,below code is used to obtain time spent from first 'Open Status' to 'In Progress Status

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 rt = [0]
def createTime=issue.getCreated().getTime() // getTime() tranfer to milliseconds
log.warn("create time:"+issue.getCreated().toString()+"to millisecond:"+issue.getCreated().getTime())
def firstStart=changeHistoryManager.getChangeItemsForField(issue, "status").find{
it.fromString=="Open" &amp;&amp; it.toString=="In Progress"
}?.getCreated()

if(firstStart){ //has Start Progress
	Duration=firstStart?.getTime()-createTime
        // NOTE: doesn't show anything if less than 60 seconds
        log.warn("Duration:"+Duration+"round:"+Math.round(Duration / 1000)+"timespent:"+DateUtils.getDurationString(Math.round(Duration / 1000)))
        def timeSpent=DateUtils.getDurationString(Math.round(Duration / 1000))
        if(timeSpent){
                return timeSpent
        }else{ //negative value or less than one minute
                return "less than one minute"
	}
}else{ //there aren't workflow transitions executed yet.
	def timeSpent = System.currentTimeMillis() - createTime
        DateUtils.getDurationString(Math.round(timeSpent/1000))
}

Andrey Markelov

Hi,

I have done it in the free add-on https://marketplace.atlassian.com/plugins/ru.andreymarkelov.atlas.plugins.datacollector

-- Andrey

Tansu Akdeniz2

Hi,

There is a Time in Status Plugin on marketplace. You can get reports depending on user, project and advanced mode. You can export the reports to excel also.

Tansu Akdeniz

Thierry Molina

Andrey

Thank you very much for your work it is very usefull

Thierry Molina

Andrey,

Thank you for your work it is very usefull

Thierry Molina

Andrey,

Thank you for your work it is very usefull

MattS

Yes, the Issue History Collector aka datacollector worked well for us

Raju Adluru

Hi Andrey, thanks for this plugin, i see lot of positive feedback on this, can we get this data in filters so that we can create report multiple issues, like status, time in that status, assignee etc. columns in filters, same can be displayed in dash board Appreciate your help and support on this. Thanks Raj

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

transition

time