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,
Gene
At 05:08 AM 6/6/2007, joey wrote:
is it possible to retroactively modify _all_ "Comments" to be
"Correspondences"?!
This surely needs to be done directly in the database.. any hints
("UPDATE .. SET")?! :)
Greets,
joey
--
Gene LeDuc, GSEC
Security Analyst
San Diego State University
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
