Status Category Changed - not accurate

[Dean Holloway]

Hi All,

It seems to be a commonly asked question to understand the time/date when a status last changed on a ticket. I'm trying to do the same, but while I'm able to see the full history which includes status changes, I'm not able to accurate track the date last changed in a field. I thought I'd found my answer with the 'Status Category Changed' field, but it's not accurate and can refer to prior status change dates (as validated in the history). Has anyone identified a field which accurately tracks the date/time of the last status change on a ticket?

Thanks in advance for any insights!

[Trudy Claspill]

Hello @Dean Holloway 

Jira does not natively provide a field for that or a function for that.

There are third party apps that could help with that.

Or you could create a custom field to track that and set the field with an Automation Rule.

With regard to the Status Category change, each status is a member of a Status Category. There are three of them and they correspond to the three colors that show for statuses:

To Do - gray

In Progress - blue

Done - green

What is tracked is the change of status that is to a different Status Category. A change between statuses of the same color (Status Category) would not update the field tracking Status Category changes.

[Dean Holloway]

Thanks for the feedback @Trudy Claspill .

We'll evaluate our options.

[Yuliia_Borivets__SaaSJet_]

Hi @Dean Holloway 

Jira does not provide a direct field that tracks the latest status change across the board. It's only presented in the History section of a single ticket. 

There are alternative ways you might consider to capture the last status change on a ticket.

1) Custom field and Jira automation.

- Create a Custom Date/Time Field

- Go to Project Settings > Automation > Create Rule

Set trigger to Issue Transitioned. Add a Condition if needed (e.g., only for specific statuses). Add an Action: Edit Issue and set your custom field (e.g., "Last Status Change Date") to the value {{now}}, which captures the current date and time of the status change.

2) Activity Stream Gadget and choose the "Issue transitioned" filtering option. 

3) Apps like Issue History for Jira developed by my team.

It presents the date and time for any field change, including statuses. You can create a report specifically for status changes for multiple issues in one place and export it if needed.

Example:

[Dean Holloway]

Thanks for the feedback @Yuliia_Borivets__SaaSJet_ !

I'll go through the options you outlined. I appreciate the details!

[Alex Ortiz]

What I do, assuming you don't want to buy a plugin that does this already, I create custom fields of the type date.  And then, I create post functions in my workflow after each transition.  I then date/time stamp that custom field in my post function so that I know exactly when an issue entered a specific status.  You need to do this for each transition and for each status.  And you need a lot of custom fields, one for each status.

I would pay the money and get the app.

[Dean Holloway]

Thanks so much @Alex Ortiz !

Yup, we'll balance the work it'll take for a custom field(s) against the benefit of buying the app.