K1000 Service Desk: Difference between Created, Time_Opened and Time_Closed Fields
I'm working on a ticket rule in response to this question: http://www.itninja.com/question/stop-tickets-closed-more-than-x-days-ago-from-being-re-opened.
The trick is to base the query on when the ticket was closed. Is the TIME_CLOSED column in HD_TICKET the time a ticket's status was changed to closed or that it went from open or stalled to a closed state?
I also noticed that the CREATED column and the TIME_OPENED column are not the same. What's the difference and why are they two separate columns?