Hi there, there are Yreas you have to handle with care:
When you delete a Customer and have tickets associated with this Customer you may run into Issues by either an Error, as the customer is not longer available or into wrong Customer associated if the customer id is reused by another Person. kind regards Kai Von: Rocco Tocci <rocco.to...@tbsit.com> An: dev@otrs.org, Datum: 21.02.2013 12:26 Betreff: Re: [dev] How to Delete Customer? Gesendet von: dev-boun...@otrs.org These SQL commands should allow to delete a Customer in not valid state Someone can 'confirm? -- 1) delete from service_customer_user where customer_user_login in (select login from customer_user where valid_id=2) -- 2) delete from customer_preferences where user_id in (select login from customer_user where valid_id=2) -- 3) delete from group_customer_user where user_id in (select login from customer_user where valid_id=2) -- 4) delete from customer_user where valid_id=2 By Rocco Il 21/02/2013 12.12, Rafa Quiñonero Figuerola ha scritto: All that things must be done from the database, you can delete tickets, users, partners, services... from database. But pay attention to don´t delete something you need!! 2013/2/21 Jignesh Kakka (jkakka) <jka...@cisco.com> Hi Team, As of now we only have an option to make customer invalid by setting Valid=0. Do we have any option to permanently delete the customer? If yes, then is are similar way for Services also? Thanks, Jignesh _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev -- Rafa Quiñonero Figuerola Tlf: 0151-61436385 rafak...@gmail.com _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev -- Rocco Tocci Application Architect Strada Prov. 1 BariModugno n. 4 70123 Bari Italy Tel. +39 0803855483 TBS IT ? Telematic & Biomedical Services Srl a socio unico Sede Legale : Via Giacinto Gallina, 4 ? 34122 Trieste Tel. 040 - 92291 Sede Operativa : Via Francesco Bettini, 13 ? 06034 Foligno Tel. 0742- 32661 C.F., P.IVA e Registro Imprese (TS) : 01165260322 Cap.Soc. ? 8.000.000,00 i.v. una società di TBS Group SpA Ai sensi del D.Lgs. 196/2003 e della normativa internazionale, vi informiamo che questo messaggio è riservato esclusivamente al destinatario. Se esso vi fosse pervenuto per errore, vi invitiamo a eliminarlo immediatamente e a darcene comunicazione. Grazie. According to the Italian and international laws in force, we inform you that this message is reserved only for the addressee. If you are not the addressee, please delete it immediately and notify us. Thank you. P Per favore, pensa all'ambiente prima di stampare questo messaggio. Please, consider the environment before printing this e-mail. _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
