Is there a way to use Status Change Time (as seen in History) as a column in Issue Filters?

unknown

So basically, what I am required to check is the difference in Date/Time between a Due Date mentioned on the top right section in a ticket to a Date/Time when a ticket falls in a particular status for the first time.

Current Workflow: I check the Due Date of the ticket which is easily available since it can be added as a column straight forward. I then open the History tab under Activity; check for the Time when the ticket moved to a Status say "X" for the first time. I then find the difference between these timings to get a exact duration between status "X" and the Due Date.

For multiple instances, its cumbersome to do this work flow hence I would like to know a best approach for this situation. If by any chance, I can have this Status change time near the Due Date, it will help me quickly process things. 

 

Would really like some thoughts here. Even a work around to this situation will help get the ball rolling

Ivan Tovbin

Hi Salil,

Columns in issue filters represent differrent issue fields. So if you want specific data displayed in one of the columns you'll have to populate a custom field with that data and then add that field as a column to your issue filters. 

Given your requirement I'd say your best bet is a scripted field which can be configured to be populated automatically with the date of the first change to a specific status for an issue. However this approach requires a 3rd party add on like ScriptRunner.