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
<mailto: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 <mailto: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. EUR 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
