Extract date when issue changed to ready for build

[Chandra Pandey]

I like to extract the date when issue changed to ready for build for a project and multiple issues. may be any python script which connects with jira api? please help 

[Emre Toptancı _OBSS_]

Hello @Chandra Pandey ,

As mentioned in other answers, you can use Jira REST API to get history data on each issue so you can filter out status changes.

You did not indicate whether you are using server or cloud but if you are using Jira Server (or Data Center) and have access to the database, you can get the same data from changegroup and changeitem tables. 

Either case, you will need to do some development to automate the extraction of this data.

If using an app is an option for you, our team at OBSS developed Timepiece - Time in Status for Jira app for this exact need. It is available for Jira Server, Data Center and Cloud.

Time in Status gives you reports showing transition dates of issues. Since an issues can visit the same status more than once, the app can show both the First and Last transition dates. The app also has reports showing how much time each issue spent on each status, each assignee, each user group.

The report output is calculated using issue histories so you can get reports for your exisiting issues as well.

EmreT

[Mehmet A _Bloompeak_]

Hi @Chandra Pandey ,

The data you need is available in Jira Rest API. It provides the exact status transition date and time for each issue. It returns json as below, then you need to extract and calculate.


For Jira cloud, you can try Status Time add-on. It generates status time report/export.
If you are looking for a free add-on, you can try the free version, Status Time Free.

[Zoryana Bohutska _SaaSJet_]

Hi @Chandra Pandey 

If you are using cloud version of Jira, you can consider Issue History (created by my team).

It let you view the full history of changes that had been made in a selected list of issues.

So you can get data and time each issue was move to any status. 

Regards

[Tuncay Senturk]

Hi @Chandra Pandey 

I am not Python guy but you can use Jira REST API to fetch issue history by using this REST service. JIRA_URL/rest/api/3/issue/{issue-key}?expand=changelog 

Then you need to get appropriate status change and extract the date you needed.

If you want to code less or even no code you can use Marketplace app. For instance Enhancer Plugin for Jira comes with status date custom fields which calculates those entry and exit dates. 

Please note that I’m one of the folks behind Snapbytes, there may be other solutions out there.

I hope it was helpful