The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

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

Comments for this post are closed

Community moderators have prevented the ability to post new 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.

TAGS
AUG Leaders

Atlassian Community Events