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