Display the date the status was changed

Question

Hello,

I'm trying to get a list of all the tickets that have changed from status A to any other status.  However, I want to see the date the status actually changed when Jira displays the results.

Here is my query:

project = ci and status changed from "1-Contract Signed" AFTER startOfYear()

It shows me all the tickets that have this criteria, but I then have to click on each ticket and look at the history to see the date it changed.

Thanks!

Mikael Sandberg · Accepted Answer

In order to display the date when the status change happened you would have to save that to a custom field, JQL doesn't allow you to display data from the history itself.

Yuliia_Borivets__SaaSJet_ · Accepted Answer

Hi @Katherine Stevens

You're right built-in ticket history is available only while opening it.

If you need to create a report with dates when statuses were changed, you can try Issue History for Jira app. Here you can filter by project, assignees, sprints, date ranges, etc.

Add to the grid any field you'd like to monitor changes for.

Example:

The add-on is developed by my team. You can check if it can help with your case.