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

Reply via email to