« October 2013 | Main | April 2015 »
March 31, 2015
Some sample OS Ticket SQL
UPDATE ost_ticket SET status = 'open' WHERE staff_id = 1 AND status = 'closed' AND ticket_id IN (SELECT DISTINCT ticket_id FROM ost_ticket_event WHERE staff = 'libper' AND state = 'closed' )
Posted by pj at 04:17 PM | Comments (0)