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