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 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: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] 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 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: marco69v@hotmail.com talk: marco.vannini@gmail.com 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