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; } } }

Obtaing issue cycle time using REST API

Robert Okemo

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

Accepted answers

All comments

Lidija_Dolinar

I also need this information.

@Robert Okemodid you find the solution?

Thank you and kind regards,
Lidija

Robert Okemo

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

Emre Toptancı _OBSS_

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 Timepiece - Time in Status for Jira 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

Nicolas Martin_6qdgxe

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,

Emre Toptancı _OBSS_

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

Robert Okemo

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

Mehmet A _Bloompeak_

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.

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

Victor Hugo Oliveira Amorim

I also want to use the API and not an add-on.

However, the API overwrites the category's update date data, always leaving the most recent and not a history like I need.

How can I capture the history of dates that got changed using the API?

Mehmet A _Bloompeak_

Hi @Victor Hugo Oliveira Amorim

You can try the changelog api with pagination.

Victor Hugo Oliveira Amorim

Thank's

Emre Toptancı _OBSS_

Hello @Victor

Our app, Timepiece - Time in Status for Jira, has ready-to-use Excel and Google Sheets template files that allow you to pull calculated Time in Status data directly into a spreadsheet. You can build your reporting starting with these templates and have single-click-refresh reports.

https://dev.obss.com.tr/confluence/display/MD/TiS+Server+and+Data+Center+-+Sample+Spreadsheet+Integration+Files

EmreT

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server

atl-orange

marketplace