Hi Stéphane! Am 16.12.2016 um 13:01 schrieb Stéphane Pouyllau: > I want just (into OTRS Admin > SQL Box) to have a SQL query to export in CSV > or Excel all tickets with, ticket by ticket all « Articles » (by No.).
So you want to use the OTRS interface to your database. OK. But that still does not tell me what database you are using; OTRS supports several of those. As far as I know export capabilities are different for different database servers. I'm far from being a database expert. Up to now I only encountered CSV exports into files. Thus possibly your restriction to the OTRS SQL box makes the whole thing impossible. Sorting the export on a per-ticket basis isn't easy when restricted to one single SQL query btw. Susan --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
