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

Hello, We use MySQL. Best, S.

Le 16 déc. 2016 à 14:13, Susan Dittmar 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