RE: [otrs] deleteting data from OTRS

Hi, Yes I think that would be a very good feature. I think also that by default if users are invalid then they are NOT shown in the list. Regards Alan Alan Mckeown JoraPh Consulting Ltd Suite 1.05 Grosvenor House Central Park Telford TF2 9TW Mobile: +44 (0)7841 996 331 Skype: joraph_alanm Office: +44 (0)8700 433877 Fax: +44 (0)1952 825058 http://www.joraph.com blocked::http://www.joraph.com/ ********************************************************************** CONFIDENTIALITY This message is confidential and may be legally privileged or otherwise protected from disclosure. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system(s); you must not copy or disclose the contents of this message or any attachment to any other person. Although we have taken steps to ensure that this e-mail and attachments are free from viruses, we advise that in keeping with good computing practice, the recipient should ensure they are actually virus free. ********************************************************************** ________________________________ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Laurent Minost Sent: 22 August 2007 11:16 To: User questions and discussions about OTRS.org Subject: Re: [otrs] deleteting data from OTRS Hi,
From which I noticed, it seems OTRS only display *current* CustomerUser and CustomerCompany informations in TicketView so except that you won't be able to get these infos when displaying a ticket, you can delete from database in customer_user and customer_company the entry for this CU and CC. I've just done a test renaming in my ticket table of otrs database the value of customer_id to an unexisting customer_id value for a specific ticket number and OTRS generate no error except it no longer displays customer informations took from customer_user/customer_company tables.
I think that frontend is lacking of a link that can "Toggle valid/invalid display" CU/CC/Users/Groups ... so when you have 100 invalid CustomerUsers you can choose to display them with valid ones or not. It could be a good feature. BR, Laurent Minost Le mercredi 22 août 2007 à 11:42 +0200, Nils Breunese (Lemonbit) a écrit : Alan McKeown wrote:
I understand that but if things don't get deleted then the admin interface for users, customers etc becomes very messy. Deleting would be a good option. Is this possible?
I don't think it's possible, or at least not a good idea. I believe that when you would delete a customer, OTRS would have to also delete all the associated tickets and other data or the database would no longer be consistent. I believe that's why there is no delete option. Setting a customer to be no longer valid makes sure that customer can no longer login, but the customer's ticket history is still available for searching for instance. Nils Breunese. _______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/ -- This message has been scanned for viruses and dangerous content by JoraPh Consulting http://www.joraph.com/ , (Server #1) and is believed to be clean. -- This message has been scanned for viruses and dangerous content by JoraPh Consulting Ltd (Server #1), and is believed to be clean.
participants (1)
-
Alan McKeown