Re: [otrs] Delete some tickets

Hi, please do not change values (update, delete, ...) in the database! Please use the scripts shipped with OTRS or the GenericAgent. Using OTRS scripts or the GenericAgent handles everthing: Update/delete the cache, delete information that belong to the ticket. (eg the SQL statements below do not delete the links between tickets etc.) Kind regards, Renée Am 23.09.2016 um 08:54 schrieb Sujeeva Tissaarachchi:

Hi, You need to connect to your database (default MySQL) and issue a delete command DELETE FROM ticket DELETE FROM ticket_history DELETE FROM article DELETE FROM article_plain

Above deletes all tickets in the system. Otherwise use the where clause Best Regards, Sujeeva Tissaarachchi

From: Personal Técnico To: otrs@lists.otrs.org Sent: Thursday, 22 September 2016, 18:21 Subject: [otrs] Delete some tickets

Hi,

I'm running OTRS 5. For testing purposes, I created some tickets that, now, I would like to delete. How can I remove them? Directly from database?

Thanks. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

-- Perl / OTRS development: http://perl-services.de OTRS AddOn repository: http://opar.perl-services.de