I am looking to filter Epics on those that have changed Status in the past 7 days. The additional component that I would like to display is what the previous status was. I am able to pull Epics that changed and display their current Status but would also like to see what they were changed from in my display results.
Thanks
Marty
Hello @Marty Monaco
Welcome to the Atlassian community.
Jira does not have a field or function natively available for displaying that information.
A Work Around would be to have a custom field in which you store the previous status, and use an Automation Rule to update that field each time the Status is changed. Or to use a workflow Post Function to set such a field.
I should have refresh my page before posting the same answer
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!
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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Actually that looks very cool. I will certainly check with my team and if there is enough interest we will take a look.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In jira, out of the box this is not possible. You can't see the previous status in issue navigator unless you create an automation rule that will catch this value and store it in a customfield.
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 !!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.