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 <tecni...@caos.uab.es>
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
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
