Assume you mean marked “dead” and for RT2.
Someone here posted a script to do that a while back. What I did was
add referential constraints to the database with cascading deletes,
and then I do this: delete from tickets where status=‘dead’
I posted the constraints here last week. They don’t work for mysql
with the default setup for RT2.
I thought mysql didn’t support cascading delete/updates since it doesn’t
support foreign keys?
Nicolae P. Costescu, Ph.D. / Senior Developer
46040 Center Oak Plaza, Suite 160 / Sterling, Va 20166
Tel: 571-434-1472 / Fax: 571-434-1478