Can I get a dump of the history in Jira such that I know when a field was updated?

[AJ]

We are using the field blocked reason and status colour to track risks of the epics. We change the status colour to red and update the blocked reason with the risk details. As soon as risk is mitigated we change the status colour to green and delete the content from blocked reason.

Now I want a dump of these changes for each epic such that I get the start date ( the date when status colour was changed to red) and the associated blocked reason. I also want the end date ( the date when status colour was changed to green). This will give me the aging of the risks as well.

right now I am manually opening every jira epic and reading through and making a note in an excel.  I really have to automate this report as this is extremely laborious task right now. Do you have any suggestions?

[Yuliia_Borivets__SaaSJet_]

Hi @AJ 

Nothing from the built-in options comes to my mind. 

- Activity stream gadget has limited filters, and there is no option to select custom ones like "status color".

- The REST API is not the best solution for getting the history of all issues, as it is explained in this conversation: https://community.atlassian.com/t5/Jira-Service-Management/Jira-rest-API-call-for-issue-history/qaq-p/2525618

Here is some instruction for REST API: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issues/#api-rest-api-3-issue-issueidorkey-changelog-get

- So, for this case, I can suggest a solution developed by my team. Issue History for Jira app provides a history report for all issues. You can select which fields you want to include in your report, for example, "status color".

I don't have the exact custom field in my project, but here is a screen of the report with issue type changes:

You can see the date for every change.

The app has additional security options as it's Cloud Fortified. There is a free 30-day trial, so you can test if it works for you.

[Amay Purohit_RVS]

Hi @AJ 

If you are open for a mktplace solution, you can try out our app

Issue History Reports

You can view the complete change log for your filtered issues along with custom field changes with ability to export to a CSV file as well. 

Do Try it out.

Disclaimer : I am part of the team which developed this app

[Ste Wright]

Hi @AJ 

You can get the Issue History via the API - although it could be quite a lot of work for your specific need.

You mention "Status Colour" - is this an App you're using?

Ste

[AJ]

Hey @Ste Wright status colour is the field in Jira associated with the epic. Green, yellow, red, no colour. This is available in my organisation’s cloud jira, we are not using any external apps for the same.

[Ste Wright]

Hi @AJ 

So it's a custom field - what type of custom field is it?

And are the options words, or emoji's (eg. coloured icons)?

---

It might be simpler for future issues to do the following...

• Create 3 Custom Fields...
  • Blocked Start Date - when Status Colour became Red
  • Blocked End Date - when Status Colour became Green
  • Blocked Reason (Keep) - a field where the Blocked Reason is copied into
• Use Automation to populate these fields as the actions occur
• Consider keeping these fields off the Screen, and just visualising them in an issue search

---

If this is of interest and you need further instructions on how to set this up, let us know what type of field it is and the options :)

Ste

[AJ]

It is a drop down which gives options in text, but when you select it shows as an icon. 

[AJ]

I am not sure I will get support to create 3 new fields so I have to work with existing history and get the date when the status colour field was changed to red and green. 

[Ste Wright]

Hi @AJ 

Then your main native option is to export the data via the API, and translate it into a readable format.

Ste