How do I find the # of days ago the last status change was made?

Ed Smith_q8rkhi

I have a particular status change that I want to query for in the history but I'm only interested in the last status change entry and how old that is.  I'm trying to find tickets that transitioned  to status = "A"  and are still in that status after 1 day, 2 days, 3 days, etc.  This is to trigger different actions based on how long a ticket has been in status = "A".

The problem I'm having is its finding older transitions to status = "A" in the history and I'm only interested in the last status = "A" change.

This is what I tried:

Project="MyProject" AND status = A AND status changed TO A during (-1d, -1d)

Returns tickets #1 and #2  that changed to status "A" 1 day ago which is correct.

Project="MyProject" AND status = A AND status changed TO A during (-2d, -2d)

Returns tickets #3 and #4  that changed to status "A" 2 days ago which is correct.  But it also returns ticket #2 because ticket #2 transitioned from "In Progress" to "A" 2 days ago, then back to "In Progress" and then 1 day ago went from "In Progress" to "A" again.

I'm only interested in the last time we changed status to "A" not the historical changes.

Any suggestions appreciated.

Tuncay Senturk _Snapbytes_

Hi @Ed Smith 

Welcome to the Community!

Unfortunately, you can't do that in an easy way.

I'd recommend using an app for this. Enhancer Plugin for Jira has lots of custom fields that you can easily target this problem.

- Status Entry Date Custom fields, you can create a date custom field to hold the status (specified) change date. You can also configure it to calculate the first/last occurrence. 

- Status Exit Date Custom fields, similar to above, you can define this custom field to keep the date of leaving a status.

- Field Change Date Custom fields, if you want to store the date of any status change you can use this custom field and provide 'Status' field.

 

Each custom field is read-only, calculated custom field and you can use them in JQL filters.

Please bear in mind that I am one of the folks behind this app.

Cheers