[rt-users] Removing Deleted Tickets

Vivek Khera khera at kcilink.com
Tue Jun 3 09:51:32 EDT 2003


>>>>> "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/



More information about the rt-users mailing list