Search result (CSV) Close Time

[ThomasPL10]

Hello everyone.

Maybe some of you know how the OTRS recon close time e.g. in CSV filme with search result. Because there's no such column i database like close_time or something.

I found that in "ticket_history" table is column "history_type_id" and the ID "27" means changing the state of the ticket then if next state is closed in "state_id" column there is value "2". In "ticket_history" table there is also "change_time" and "create time" columns. Which actually are the same and are the time of closing ticket. Of course there is also "ticket_id" column which connects the "ticket_history" with "tickets" table

But is this so complicated that to recon the close time? Maybe there is some easier way to export that information from the database?

Untitled.png

Thanks for any ideas.

[crythias]

note that create_time and change_time are timestamps for the record entry (when it was entered, and theoretically if it gets modified.)
close_time is (IIRC) considered the last state change that makes the ticket closed.