Re: Delete some tickets
Renee B <[email protected]>
| Newsgroups | gmane.comp.otrs.user |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]> > To: [email protected] > 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 --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs