JQL to capture the date when a story changes status from New to In progress

Question

Hello,

I need to generate a report to capture the start and end date for each story in my sprint.  Looking a the delivered reports, I have not been able to find anything that provides this info.  I was trying to build a jql statement that could pull the information.  I have identified the Resolved field to capture the end data, but am not able to identify how to capture when the story moves from the New status to In Progress.

How can I accomplish this?

Madhu_RVS · Answer

Hi @Lori Benowitz

Welcome to the community !!

You can use Jira API's to extract this data. Or use a mktplace app for the same.

Please try out an add-on we have developed for the same use case.

Time in Status Reports

The status transition details report shows when the issue was transitioned to which status and on which date and by whom. Also the app has 20+ reports to track your bottleneck Issues & Processes.

More details here

Disclaimer : I work for the vendor who built this app

Petru Simion [Simitech Ltd.] · Answer

You can use CIFJ - Issue History Dashboard for Jira, an app that our company recently released to track history changes and export the result to CSV.

https://marketplace.atlassian.com/apps/1235591/cifj-issue-history-dashboard?hosting=cloud&tab=overview

Yuliia_Borivets__SaaSJet_ · Answer

Hi @Lori Benowitz

Jira automation might work for you to capture a date when the status moves from one to another. Look at the example (option 2) in this article: How to capture the “date of change” for Jira issues

Also, you can check a solution developed by my team - Issue History for Jira. It captures "date of change" for all fields and issues in one report. You can customize it to see only specific changes like New status to In Progress.