Got some help from OTRS support, so now we have found the correct documentation
and the documentation is good :)
http://otrs.github.io/doc/manual/developer/stable/en/html/otrs-module-layers.html#genericinterface-modules
Morten
Fra: otrs-boun...@otrs.org på
Hi Folks,
Considering the 10.000 limit for closed tickets, I wonder how can I find a
ticket older than 10.000. My system has now over 25.000 tickets in one year
and 4 months.
I tried seach, but it didn't find it.
I user OTRS 4 running on Linux and MySql database.
Thanks
--
*André Luiz C. e Ca
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 c
