Hi,
Varsani, Rajendrakumar (PSD) schrieb:
Hi folks,
We're trying to work out what kind of calls and how many calls we get
before 9am as management is considering moving our HelpDesk time from a
9am start to an 8:30am start(!)
We've created some SQL along the lines of:
SELECT id, create_time, FROM ticket WHERE HOUR(create_time) < 9;
Which gives us 155 or so rows of data. However, how do I find out the
Ticket Number for each of the ID and CREATE_TIME pairs returned? We've
looked at the E-R diagram but are baffled!
Ticket# is stored in ticket.tn
Rajendrakumar Varsani
Bye, Alex
_______________________________________________
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 oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
