entire history of 1 issue using JQL

Question

I have one issue and it is in closed status, and i want to show all the records of that issue using JQL from open to closed.. so filter output should be  key, creation date, updation date, status

so the output should have 1 row for each status.. till closed status..

pls help. thanks in advance.

Yuliia_Borivets__SaaSJet_ · Answer

Hi @Vasikaran

With JQL,  you can only search for status changes like status CHANGED FROM "Open" TO "Closed". However, the result will not display additional info (when the issue was created and updated).

The report you need can be configured with Issue History for Jira from my team. It displays the full history from the moment of issue creation. The available filters can help to create a report that will include status changes and the date of each update.

Example of a report for a single issue:

Example for multiple issues (you can select the ones you need):

Also, you can select a specific transition like "Open-Closed" and check its updates.

Stephen.Lugton · Answer

Hi @Vasikaran

If I understand correctly what you're trying to do, i.e. list out every date on which the status changed for an issue, then it's not possible using normal JQL, your best bet is to see if there is an app that will do what you want on the Atlassian Marketplace and do a search for issue history, or just history.  But even if you do use an app you will only be able to view issue history from the time of installing the app.