Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Obtaing issue cycle time using REST API

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?  

ps:

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

 

Thanks

 

 

 

 

3 answers

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.
JiraRestAPIOutput.png

Or you can use Status Time app. If you are looking for a free app you can try the free version Status Time Free.
IssueScreenView-3.gif

I also need this information.

@Robert Okemodid you find the solution?

 

Thank you and kind regards,
Lidija

Unfortunately I did not get any answer on it. Still waiting...

Like Lidija_Dolinar likes this

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.

Emre Toptancı

OBSS

Hello @Emre Toptancı _OBSS_ 

Im' interested to try your add-on.

2 questions:

(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

thanks,

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:

https://dev.obss.com.tr/confluence/display/MD/TiS+v4.5+-+REST+Reporting

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.

https://dev.obss.com.tr/confluence/display/MD/TiS+Cloud+-+Exporting

EmreT

Great!  Thank you!  I'll look into this plugin.

Hi @Robert Okemo 

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:

Grouping time in statuses to get the Cycle and Lead Time 
- Ability to view reports as Charts
- Available Gadget for Jira Dashboard

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
Best Regards

@Zoryana Bohutska _SaaSJet_

Did you have the JSON API for your Time in status for Jira Cloud by SaaSJet ?
I don't see any in your docs. 

 

Cheers, Brennon

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you