[otrs] Archived mails

Hello, is there a way to display all tickets which are archived in the database? I thought something like : select tn from ticket where archive_flag = '1' would do the trick, or did I forget something? Regards, -- Pascal den Bekker - Junior Linux Systemadministrator email: pascal_den.bekker@affinitas.de skype: denbekker www.edarling.de www.betterdate.de Affinitas GmbH | Kohlfurter Straße 41/43 | D-10999 Berlin Eingetragen beim Amtsgericht Berlin, HRB 115958 Geschäftsführer: Lukas | David | Kai | Christian Brosseder | Khalil | Rieke | Vollmann