« TAL on-error attribute | Main | Python MARC record cleaner »
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' )
Tags: MySQL
Posted by pj at March 31, 2015 04:17 PM