nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

AJ_pe10rr

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?

Accepted answers

All comments

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_pe10rr

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_pe10rr

It is a drop down which gives options in text, but when you select it shows as an icon. PNG image.jpeg Screenshot 2023-12-01 at 10.17.37 AM.jpeg

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

Issue History.PNG

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud