Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

entire history of 1 issue using JQL

Vasikaran
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 11, 2024

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. 

2 answers

1 vote
Yuliia_Borivets__SaaSJet_
Atlassian Partner
December 16, 2024

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:

status changes for single issue.png

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

2024-12-16_11-00-53.png

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

Reopened issues history.gif

 

0 votes
Stephen_Lugton
Community Champion
December 16, 2024

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events