Can I display the value of Status, the Previous Status to be specific, from a Jira Issue's history?
6 answers
welcome to the community!
Just to add to Trudy's answer: If you're open to solutions from the Atlassian Marketplace, you may want to have a look at 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 long list of so-called history columns that aren't natively available, including your issues' previous 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 Excel or CSV in just two clicks.
This all just works - there's no scripting or automation whatsoever required.
Any questions just let me know,
Best,
Hannes
You can check out this thread: https://community.atlassian.com/t5/Jira-questions/Is-it-possible-to-get-the-issue-history-using-the-REST-API/qaq-p/510094
The second top answer shows how to get status changes using the JIRA REST API.
If you are open to trying add-ons, check out Issue History for Jira developed by my team.
You can create a report with the status transition like the one below. You will get status transition history for every epic.
Hi @Marty Monaco,
Creating an automation rule to populate a custom field is possible, but please note that it will only take effect moving forward, from the moment the rule is established. Existing issues will not be retroactively updated.
Saving the value in custom fields is also a problem when you want to analyse the data of multiple issues at once.
Another option is to extract data from the history if the issues, which is possible, but very work intensive considerring the implementation and testing.
If you are open to using apps, consider using the Issue History Dashboard for Jira app, developed by our company.
This app enables you to search and analyze issue history for specific projects. For your use case, you can:
- Narrow down the search to a specific week
- Filter by the 'status' field updates and issue type to be 'Epic' (This particular example is not using the issue type field filter but you can use it)
This will provide a clear view of the status changes, including the 'Value From' (previous status) and 'Value To' (new status) values."
Additionally, the dashboard displays the Issue Key, Project Name, and Project Key, allowing you to identify the issues being modified. You'll also have access to other fields if needed.
For convenient navigation, values in blue are clickable links, enabling you to open the specific page related to the value in each column.
Furthermore, you can export your search results to CSV format, allowing for seamless further data analysis, charting, and other customization options.
Regards,
Petru.
Welcome to the community !!
You can use Jira Rest API's and build your own custom solution or if you are open to explore mktplace apps for detailed and flexible reports do try out
The app shows the complete history of changes for your filtered issues. Including the status changes you are looking for.
Disclaimer - I am part of the app team
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.