Re: export with SQL querie(s)
Stéphane Pouyllau <[email protected]>
| Newsgroups | gmane.comp.otrs.user |
|---|---|
| Message-ID | <[email protected]> |
Hello, We use MySQL. Best, S. > Le 16 déc. 2016 à 14:13, Susan Dittmar <[email protected]> a écrit : > > 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 -- Stéphane POUYLLAU Ingénieur de recherche CNRS Directeur technique d'Huma-Num http://www.huma-num.fr http://humanum.hypotheses.org Twitter : http://twitter.com/spouyllau Blog perso : http://blog.stephanepouyllau.org --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs