they are searchable within otrs too if you select in search popup add another attribute: Archive search and then you can print output to csv ... is easier, don't you ? On Fri, May 4, 2012 at 5:09 PM, Pascal den Bekker < pascal_den.bekker@affinitas.de> wrote:
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
--------------------------------------------------------------------- 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