Re: export with SQL querie(s)
Susan Dittmar <[email protected]>
| Newsgroups | gmane.comp.otrs.user |
|---|---|
| Message-ID | <[email protected]> |
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