Re: [otrs] export with SQL querie(s)

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