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
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/