Great ! Tx a lot Bruno.
BTW wouldn't be a nice to have in stat something similar in the future ? Ciao. MV On Wed, May 14, 2008 at 5:57 PM, Klaus Bruno <[EMAIL PROTECTED]> wrote: > Hi all > > select tn, create_time, change_time from ticket where (ticket_state_id = > 2 or ticket_state_id = 3); > > ticket_state_id = 2 closed successful > ticket_state_id = 3 closed unsuccessful > > regards, > Bruno > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Marco Vannini > Sent: Wednesday, May 14, 2008 4:53 PM > To: User questions and discussions about OTRS.org > Subject: Re: [otrs] How get time when ticket was close? > > Hi, > > I'm interested too, either if I've ask if someone has an sql > statement, but noone has answered. > I know that there are other peoples interested. > Could it be a request of feature for a next release to have time > spent in all state for a ticket or at least from open to close state ? > > Thank you very much > > Cheers. > > MV > > On Wed, May 14, 2008 at 4:21 PM, lidia sviderska > <[EMAIL PROTECTED]> wrote: >> Hi all! >> I want get time created ticket and time when ticket was closed in > CSV >> format via Search. There is time created, but nothing about time when >> ticket was closed. >> Help me, please >> Lidia >> >> >> _______________________________________________ >> OTRS mailing list: otrs - Webpage: http://otrs.org/ >> Archive: http://lists.otrs.org/pipermail/otrs >> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs >> Support or consulting for your OTRS system? >> => http://www.otrs.com/ >> > > > > -- > Marco Vannini > home: +39 02 900091454 > mobile: +39 335 5340819 > msn: [EMAIL PROTECTED] > talk: [EMAIL PROTECTED] > icq: 58389316 > skype: marco69v > _______________________________________________ > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > Support or consulting for your OTRS system? > => http://www.otrs.com/ > _______________________________________________ > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > Support or consulting for your OTRS system? > => http://www.otrs.co _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/