I'm trying to get the issue cycle time (similar to what shows up in JIRA Control Chart Report. I am using JIRA version 7.10
Anyone has ideas on how to do this?
I don't want to use add-ons. This information is available in JIRA. I just want to know how to extract it using Atlassian's REST API
Hi @Robert Okemo ,
Issue status history data is available via Jira Rest API. It provides the exact status transition date and time. It returns json as below, then you need to extract and calculate the date differences.
Hello @Robert Okemo ,
Unfortunately, Jira does not give this information directly.
If you want to do this yourself, you will have to use make a REST call for each issue to get its history and traverse through issue history to do the calculation yourself.
I know you said you don't want to use add-ons but for those who visit this question with similar needs, our team at OBSS created Time in Status app for this exact need. It is available for Jira Cloud, Server and Data Center.
The on-prem versions of Time in Status also have a REST API that you can feed the parameters and get the calculated data as CSV with a single REST call.
Using Time in Status you can report how much time each issue spent on each status, each assignee or even each user group. (useful for calculating lead/cycle times and identifying bottlenecks in your process). You can also see the number of times each status or transition was used (very useful for inspecting things like reopen counts). You can also list the status entry/exit dates.
You can produce reports based on the default 24/7 calendar or define your own business calendars with custom workdays and working hours.
All data can be exported as XLS, XLSX, CSV.
Hello @Emre Toptancı _OBSS_
Im' interested to try your add-on.
(i'm on a cloud server Jira)
- What does mean the on-prem version? Do not sees it mentionned on the pricing page https://marketplace.atlassian.com/apps/1211756/time-in-status?hosting=cloud&tab=pricing
- Could you specify the exact call and parameters to get access to this data via the api? I do not see his info on https://dev.obss.com.tr/confluence/display/MD/TiS+Cloud+-+Exporting
Hello @Nicolas Martin ,
By on-prem I mean Time in Status (by OBSS) hosted on Server and Data Center editions of Jira (Jira that you host on your servers).
Time in Status REST API is currently available only for Jira Server and Jira Data Center. We have plans to introduce a REST API for cloud platform as well. File Export option is available on all platforms.
The details for the REST call (that is available for Jira Server and Data Center) can be found here:
If you are using Jira Cloud, Time in Status (by OBSS) can still give you the calculated data but you will need to get the export file manually for the time being.
As an alternative solution, you can try Time in status for Jira Cloud by SaaSJet.
Besides 7 kinds of reports, data export and other standard functionality, this app has such advanced features:
Also, using add-on Time Between Statuses you can customize the calculation to get the Cycle and Lead Time of your Jira issues by setting the start/stop/pause timer preferences.
Hope this information will be useful for you
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events