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

[Deleted user]

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.