Delete some tickets - otrs - OTRS mailing lists

newer
how to show process ticket...

Delete some tickets

older
Agent and User simultaneously

Personal Técnico

22 Sep 2016 22 Sep '16

12:51 p.m.

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.

Reply

Sign in to reply online Use email software

Show replies by date

Smulsky, David

22 Sep 22 Sep

12:57 p.m.

Make a new queue (or use the Junk queue that comes out of the box), then create a Generic Agent to select and Delete all of the tickets in that queue either as a scheduled event or one-time run. Details: http://blog.otrs.org/2011/08/04/otrs-tips-tricks-create-a-junk-queue-that-de... Dave

Reply

Sign in to reply online Use email software

Sujeeva Tissaarachchi

23 Sep 23 Sep

6:54 a.m.

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

Reply

Sign in to reply online Use email software

Renee B

8:26 a.m.

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

Reply

Sign in to reply online Use email software

3221

Age (days ago)

3222

Last active (days ago)

Download

3 comments

4 participants

tags

participants (4)

Personal Técnico
Renee B
Smulsky, David
Sujeeva Tissaarachchi