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