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.tocci@tbsit.com>
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) <jkakka@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
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