I never did figure out how to use the Generic Agent to automatically
mark closed tickets as answered, so I figured I'd just write a sql query
and run it on a schedule.  Here is the query I came up with if anyone is
interested..

UPDATE ticket T 
INNER JOIN ticket_state TS ON T.ticket_state_id = TS.id
  SET T.ticket_answered = 1
WHERE 
  T.ticket_answered = 0
  AND TS.type_id = 3;

-----
Jack Doyle, Network+
Systems Operations Specialist
Lewis-Gale Clinic Information Systems 
_______________________________________________
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/

Reply via email to