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?
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.
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.
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.
Disclaimer : I work for the vendor who built this app
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
... 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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.