Alex, Can you explain what is the Generic Agent, or how one gets to it via the GUI. i.e. what is the url looklike. I have been trying to see ALL the open tickets that our agents have, and this might be the trick. Thanks Tom French Network Administrator DEI Services Corp. 7213 Sandscove Court Suite One Winter Park, FL 32792 Ph. 407-678-3388 ext.208 Fax 407-678-8008 tfrench@deicorp.net www.deicorp.net The information transmitted (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is intended only for the person(s) or entity/entities to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient(s) is prohibited. If you received this in error, please contact the sender and delete the material from any computer. -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Alexander Scholler Sent: Tuesday, April 25, 2006 1:01 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Deleting new tickets Hi Aaron, aaron schrieb:

Is there any danger in using the following method to wipe out new (untouched) tickets?

DELETE FROM ticket WHERE queue_id = 123 AND ticket_state_id = 456;

I think you get rid of the tickets you aim to with this method, but other informations of the tickets (e.g. attachments) won't be deleted with this method. You should use the Generic Agent instead, that's safer and cleaner. Use the WebGUI of the agent or see ~/Kernel/Config/GenericAgent.pm.examples (here 'delete').

aaron

Bye, Alex _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/