You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Join now to unlock these features and more
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.
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.
@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, 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.
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.
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.
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
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
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.
Hope it helps.