[rt-users] Delete tickets

[Odhiambo Washington]

* Frances Russell <frussell at msi.com.au> [20021114 08:50]: wrote:
> I need to completely delete tickets from one of our queues. This queue deals
> with HR issues so there are privacy legislation considerations: We cannot
> store the data even as "dead" tickets.
> 
> Is there a way to safely remove tickets from the MySQL DB?
> 
> I am using RT 2.13 on Redhat 7.2
> 
> Thanks in advance



You can do:


select id from Queues where Name='hr';	# Assuming the hr queue is called "hr"
select * from Tickets where Queue='11';	# Assuming the first query gave 11

Actually, in the second query, you can use DELETE instead of select.
I accept no responsibility for any damage!!

:-)

        cheers
       - wash 
+----------------------------------+-----------------------------------------+
Odhiambo Washington, wash at wananchi.com	. WANANCHI ONLINE LTD (Nairobi, KE)  |
http://ns2.wananchi.com/~wash/		. 1ere Etage, Loita Hse, Loita St.,  |
GSM: (+254) 722 743 223			. # 10286, 00100 NAIROBI             |
+---------------------------------+------------------------------------------+
"Oh My God! They killed init! You Bastards!"  
						 --from a /. post