Hello André, If you want to find out whats the oldest ticket closed, run the following query:
SELECT tn, create_time, MIN( id ) FROM ticket WHERE ticket_state_id IN ( SELECT id FROM ticket_state WHERE type_id =3 ) You could count them replacing the first line for: SELECT COUNT( tn ) And you could list them all replacing the first line for: SELECT tn, create_time And appending the following line at the end: ORDER BY `ticket`.`create_time` ASC I hope it helps. Regards, Leonardo Certuche
--------------------------------------------------------------------- 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