Hey there,
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
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