[rt-users] Removing Deleted Tickets

[Vivek Khera]

>>>>> "JL" == Jonas Lincoln <lincoln at unit.liu.se> writes:

JL> What is the correct way to go if I want to remove all tickets marked as 
JL> "deleted"?

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.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera at kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/