[rt-users] global: change "Comment" to "Correspond"

Gene LeDuc gleduc at mail.sdsu.edu
Wed Jun 6 11:41:12 EDT 2007

A query like

    UPDATE Transactions SET Type = 'Correspond' WHERE Type = 'Comment'

might do the trick.  As far as I've been able to tell, the only place that 
Comments are distinguished from Correspondence is in the Type field of the 
Transactions table.  But I'd sure be trying this on a non-production 
database first!  If it works, that query will affect every ticket in every 
queue, regardless whether it's been resolved, deleted, or has any other status.

Cross your fingers and good luck,

At 05:08 AM 6/6/2007, joey wrote:
>is it possible to retroactively modify _all_ "Comments" to be
>This surely needs to be done directly in the database.. any hints
>("UPDATE .. SET")?! :)

Gene LeDuc, GSEC
Security Analyst
San Diego State University 

More information about the rt-users mailing list