Update customer in database

Moderator: crythias

Locked
Fverdirame
Znuny newbie
Posts: 2
Joined: 30 Jul 2015, 12:15
Znuny Version: 4.0.8
Real Name: Ferdinando Verdirame
Company: VisitBritain

Update customer in database

Post by Fverdirame »

hi guys,
is it possble update the customer of ticket directely from the database?

I tried:

Code: Select all

UPDATE ticket
SET customer_id='name@email.com', customer_user_id='name@email.com'
WHERE id = 324;
but nothing happened (I'm using otrs5)

Thanks for your help
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: Update customer in database

Post by reneeb »

You shouldn't update the database directly, you should use the API instead (http://otrs.perl-services.de/docs/otrs/ ... icket.html -> TicketCustomerSet).
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Locked