How can I get historical data for REQ or epic or bug?

[Sam]

Hi there,

Is there a way for Jira to pull out all the historical data for a REQ, epic or bug? For example I would like to know all the state transitions from "in progress" to "open" and back to "in progress" and so on including its time stamps. I had read somewhere that for each req, epic of bug, Jira keeps a change log. Is there a way to query that change log? Ultimately what I am attempting to do is to get a complete history of specific fields  for my req and obtain a csv dump that will allow me to do more detailed low level analysis on the req. In previous tools that I have used this was possible to do where each change appeared as a separate row in the csv dump. I am not looking for an API solution or one where I would need to individually go through the history section of all the REQs, epics or bug which are in the thousands. Any help would be much appreciated.

Regards
Sam

[Yuliia_Borivets__SaaSJet_]

Hi @Sam 

With JQL it's possible to search for history of transitions like => status changed FROM "In Progress" TO "Open". However, as far as I know, it won't show timestamps for each change. So, it is not possible to achieve this with native JQL alone.

You can search for some apps that can enhance this functionality if you are open to thirds-party apps.

The one that can help in this case is developed by my team. It's called Issue History for Jira and provides timestamps for every change. 

1. You can write JQL to include issuetypes you need (req, epic, bug).

2. Select transitions you are interested in.

3. Get the report and export it as an SCV file.

The app is free for teams of up to 10 users, and there is a free trial.