Hello I recall (I think) this being mentioned somewhere on the mailing list, but cannot for the life of me find it (obviously using incorrect search criteria).
I need to close a whole bunch of tickets, and would like to use raw sql to achieve this. I've been grepping/searching around without success. For example: to close all tickets with queue_id=11, and which are in ticket_state 1||4. Obviously a couple of tables need to be updated, but without a more specific knowledge of the table relationships, I'm plonking around uselessly. update ticket set ticket_state_id=2 where queue_id=11 and... update some_other tables... Any help would be appreciated. Thanks Henry -------------------------------------------------------- This message was sent using MetroWEB's AirMail service. http://www.metroweb.co.za/ - full access for only R73. Free Web Accelerator, WebMail, Calendar, Anti-Virus, Anti-Spam, 10 emails, 100MB personal webspace, and more! Phone Now! 086 11 11 440 _______________________________________________ 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/
