desc ticket_history; | id | | name | | history_type_id | | ticket_id | | article_id | | system_queue_id | | valid_id | | create_time | | create_by | | change_time | | change_by |
Desc ticket_history_type; | id | | name | | comments | | valid_id | | create_time | | create_by | | change_time | | change_by | Select id, name from ticket_history_type; I get 34 rows.. the ones that are interesting are 13 and 14 (Closed successful and unsuccessful) at least. So...., select create_time, history_type_id from ticket_history where ticket_id = 1444; With the result u should see what you need to do :) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of sharif islam Sent: quarta-feira, 13 de Julho de 2005 16:21 To: User questions and discussions about OTRS.org Subject: Re: [otrs] Ticket Age data On 7/12/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > you'll need to look at ticket_history. But search for all the rows that havfe > that same ticket_id. > After that, you just need to find the create action and the close... and do > the math. So here's my data. The ticket was created on 11-19 10:06 and closed 11-19 10:46. I am not sure how I can do the math with a SQL statement. I need to do something like this select timediff(2004-11-19 10:46:06 ,2004-11-19 10:06:0) | ticket_id | create_time | change_time | 1444 | 2004-11-19 10:06:07 | 2004-11-19 10:06:07 | | 1444 | 2004-11-19 10:06:07 | 2004-11-19 10:06:07 | | 1444 | 2004-11-19 10:06:07 | 2004-11-19 10:06:07 | | 1444 | 2004-11-19 10:44:15 | 2004-11-19 10:44:15 | | 1444 | 2004-11-19 10:44:15 | 2004-11-19 10:44:15 | | 1444 | 2004-11-19 10:46:06 | 2004-11-19 10:46:06 | | 1444 | 2004-11-19 10:46:06 | 2004-11-19 10:46:06 | | 1444 | 2004-11-19 10:46:06 | 2004-11-19 10:46:06 | | 1444 | 2004-11-19 10:46:06 | 2004-11-19 10:46:06 _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting fr Ihr OTRS System? => http://www.otrs.de/ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
