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

Lori Benowitz
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 12, 2024

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?  

5 answers

1 vote
Yuliia_Borivets__SaaSJet_
Atlassian Partner
October 31, 2024

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.

date of change for status transition.png

 

0 votes
Madhu_RVS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 5, 2024

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

TIS - Status Transition Dates.PNG

0 votes
Petru Simion _Simitech Ltd__
Atlassian Partner
November 4, 2024

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

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 13, 2024

Hi Lori - and Welcome to the Atlassian Community!

Please do not create duplicate questions. This is a duplicate of https://community.atlassian.com/t5/Jira-questions/Extract-date-when-story-changes-from-New-to-InProgress-using-JQL/qaq-p/2811104 and I am closing this one. 

 

0 votes
Hannes Obweger - JXL for Jira
Atlassian Partner
September 12, 2024

Hi @Lori Benowitz

welcome to the community!

Status transition dates are captured as part an issue's history (you can see it if you click on the history tab in the issue view), but aren't available via JQL. 

What some people do is to use Jira Automation to trigger a rule whenever an issue transitions from one status to the other, and write the date/time into a custom field. This custom field can then be used in JQL, and/or be added to your issue search result.

Alternatively, if you're open to solutions from the Atlassian Marketplace, there's a number of apps available that can help with this. I'll provide more information below.

Hope this helps,

Best,

Hannes

Hannes Obweger - JXL for Jira
Atlassian Partner
September 12, 2024

... and to expand on my last point: If you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you'd do in e.g. Excel or Google Sheets. It also comes with a number of so-called history columns that aren’t natively available, including an issue's date of transition from [status] to [status], time in [status], or time between [status] and [status].

This is how it looks in action:

date-of-transition.gif

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Of course, you can also export your data to XSLX (Excel, Google Sheets) or CSV in just two clicks. 

Any questions just let me know,

Best,

Hannes

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events