Need to way to access the Transition Statuses and Date Changed

[dhames]

I need to access the Transition of an issue, particularly the date and time it changed. This information is in Jira under the Activity tab Transitions.

Can these Transition values be retrieved via JQL, ScriptRunner, Groovy Scripts, etc.? I am trying to prevent purchasing another Plug-in if possible.

Has any one done this? This is a basic need for an Agile project. Thanks in advance for any help or tips you can offer.

[Kian Stack Mumo Systems]

@dhames, 

Can you explain how you want to see/use these values? I'm sure there are a number of ways to get the values you want, but understanding what you are trying to do with the information would help generate a recommendation.

One really easy way to do this out of the box would be to create a custom date time field for the transitions you want to track. Then set up an automation rule that stores the current date/time when the issue transitions.

Thanks,

Kian

[dhames]

@Kian Stack Mumo Systems Thank you for your reply. I need to know when an issue transitions from To Do status to In Progress status. Ideally, it would use the statusCategory to be agnostic to workflows.

I am trying to track several Agile metrics. To track Cycle Time, I need the date/time an issue entered In Progress and then calculate the time in Progress when the issue transitioned to Done and use the resolved date.

It seems like it would be simple to do and a very useful ability to have for Agile projects. You are correct; there are many ways to solve this, and I was researching the use of automation to populate a custom field.

If I could access the date time stamp already in Jira and display it in the Transitions Activity tab, I could do the rest myself. Does this make sense? What ideas do you think would be most straightforward? Thank you.

[Kian Stack Mumo Systems]

Yes.

Have you taken a look at the control chart before? It sounds like just what you are looking for.

[dhames]

Kian, I did take a look at the Control Chart, and it is very effective in showing the overall WIP. I am looking for a slightly more granular solution than the Control Chart.

I am testing the Time in Status Free app, and it does supply the granularity I need but is extremely limited in its capabilities compared to the paid version of Time in Status.

I appreciate your reply and suggestions. Thank you.

[Emre Toptancı _OBSS_]

Hello @dhames 

Jira does not provide this functionality out-of-the-box. JQL queries can "filter" issues but they can't make calculations and they do not show transition dates as columns in their result set. The required data is available in each issue's history but you will need to use a marketplace app to get ready-to-go reports.

Our team at OBSS built Time in Status for this exact need. It is available for Jira Server, Cloud, and Data Center.  

Time in Status has duration-based and date-based reports.

Time in Status mainly allows you to see how much time each issue spent on each status or each assignee. 

   

You can combine the time for multiple statuses to get metrics like Issue Age, Cycle Time, Lead Time, Resolution Time etc. 

You can also use the date-based reports to see the transition dates from/to a status.

For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example total in-progress time per customer or average resolution time per sprint, week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) or sprints is particularly useful here since it allows you to compare different time periods or see the trend. 

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well. It supports both Company Managed and Team Managed projects for Jira Cloud.

Time in Status reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts. You can also get file exports and REST API access.

  

https://marketplace.atlassian.com/apps/1211756/

EmreT

[dhames]

Emre, thanks for the suggestion. I am evaluating the Time in Status Free version currently, but I think it is going to be too limited in capability to accomplish what I am after. So, I am faced with trying to justify a new paid App, pull out my Groovy skills, and write some scripts to pull what I need. Thanks, I will keep the paid version in mind.

[Emre Toptancı _OBSS_]

Hello @dhames ,

Please note that our app, Time in Status by OBSS, does not have a free version. There are other apps with similar names so make sure you are trying the correct one.

EmreT

[RVS_Support]

Hi @dhames 

You can use Jira Rest API's to pull this data. Or if you are fine to try out a mktplace app for this use case, take a look at 

Time in Status Reports 

The below report shows the transitions changes details. The app has 20+ reports to meet a variety of use cases.

Do try it out.

Disclaimer : I work for RVS, the vendor for this app

[Bloompeak Support]

Hi @dhames

I can suggest using free versions of marketplace apps since you don't prefer to purchase a marketplace app that fulfills your needs..

You can try Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.

Here is the online demo link, you can see it in action and try without installing the app. For status transition dates, you can have a look at Status Count And Entry Dates report. Entry date(see In Development, Ready for Testing, In Testing, In Development columns.) is status transition date and status count(see #In Development, #Ready for Testing, #In Testing, #In Development columns) is how many times an issue is entered to this status. This report also shows how much time is passed in each status.

For further details, please see Status Time Reports How to Videos. 

• This app has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, cycle time and lead time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

• You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
• Status durations are calculated according to the working calendar you define. Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days.
• You can set different duration formats.
• You can export reports in CSV file format and open them in MS Excel.
• You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
• You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

Status Time Reports Free is the completely free and the limited version of Status Time Reports app.

Hope it helps.