[rt-users] Updating Ticket Status via PostgreSQL

[Aaron W. Swenson]

I'm sure this has been answered by someone somewhere, but my Google-fu 
is not helping me.

I have a few hundred tickets in a production system that I want to 
change the status with some criteria a bit more sophisticated than RT 
(4.2.12) is allowing me to do.

The SQL I want to issue is:

    UPDATE tickets
       SET status = 'noresponse'
     WHERE status = 'open' AND told < '2015-11-01'
       AND told > lastupdated;

The last condition is the one I can't enter in RT.

Effectively, update the status of all tickets that are still open to 
"noresponse", where the last update was us sending the requester an 
email.

Is this safe? Is there something else I should be updating as well?

Thank you in advance.

- Aaron