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

Hi Stéphane! Am 14.12.2016 um 09:13 schrieb Stéphane Pouyllau:

I think is a « classic » question but I want to export all items of all tickets to CSV file. What’s the SQL query ? Is there a guideline or an OTRS SQL queries « almanac » ?

I vaguely remember CSV export capabilities of SQL, though I'm not sure whether those commands are SQL standard or brand-specific extensions. Before I go on a hunt for those, some questions. What database backend (which database server software) do you use? Do you need to group information by ticket? What do you want to archieve? Do you want to have some kind of human-readable backup? In that case, is CSV necessary or would another human-readable format work for you? Susan