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
An: dev@otrs.org,
Datum: 21.02.2013 12:26
Betreff: Re: [dev] How to Delete Customer?
Gesendet von: dev-bounces@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)
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
rafakorp@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
