Looking for Solution Time in OTRS Database

[intrepidfroot]

Hi,

Am wondering where (in which table/field) the "Solution Time" value is stored in the OTRS database, or if it's automatically calculated each time a ticket is viewed?

Any assistance would be appreciated.

[crythias]

Code: Select all

    $Data{SolutionTime} = $Data{Closed};

Kernel/System/Ticket.pm
sub _TicketGetClosed
Which, basically, returns the last closed state (create_time of ticket_history in one of the states of state type closed) as the solution time.