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