[rt-users] Delete Tickets

[Ruslan Zakirov]

On 3/17/06, Carles Molgo <carles at lleida.net> wrote:
> Hi,
>
>     There's any way to delete all tickets that Subject contains a
> specific word?
>
>     Can I do an update to my database like "UPDATE Tickets SET
> Status='delete' WHERE Subject LIKE '%word"' and (Status='new' or
> Status='open');" ? I have 7000 tickets to delete.
It's better to use API for such things.
You can use simple script like attached one to do such things.

>
> Thanks!
>

--
Best regards, Ruslan.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: rt-bulk-action.pl
Type: application/x-perl
Size: 581 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060320/c9f965df/attachment.bin>