Need to use customer with multiple IDs in OTRS Appliance

Moderator: crythias

Locked
ltkvien
Znuny newbie
Posts: 8
Joined: 17 Dec 2014, 10:30
Znuny Version: 4.0.3

Need to use customer with multiple IDs in OTRS Appliance

Post by ltkvien »

I'm using OTRS appliance 4.0.3 and I need to add an user A to view the company tickets of two companies ABC and XYZ, but I could not add the user A with 2 customers IDs.

Kindly advise how to setup and seems to be the OTRS appliance which uses PostgreSQL database and I don't know how to manage.
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: Need to use customer with multiple IDs in OTRS Appliance

Post by reneeb »

Add column 'customer_ids" in the customer_user table, Add UserCustomerIDs field in mapping (see https://github.com/OTRS/otrs/blob/rel-4 ... s.pm#L1383). Please do not edit Kernel/Config/Defaults.pm, but put the CustomerUser configuration in Kernel/Config.pm
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
ltkvien
Znuny newbie
Posts: 8
Joined: 17 Dec 2014, 10:30
Znuny Version: 4.0.3

Re: Need to use customer with multiple IDs in OTRS Appliance

Post by ltkvien »

reneeb wrote:Add column 'customer_ids" in the customer_user table, Add UserCustomerIDs field in mapping (see https://github.com/OTRS/otrs/blob/rel-4 ... s.pm#L1383). Please do not edit Kernel/Config/Defaults.pm, but put the CustomerUser configuration in Kernel/Config.pm
Hi reneeb, thanks a lot. But could you instruct more detail because I don't know much about PSQL and linux command:

1. Add column 'customer_ids" in the customer_user table: how to add this column in Postgres SQL
2. Add UserCustomerIDs field in mapping: Where can I add line 1383 to Config.pm? Which line will I add the line 1383 to it?

Kindly advise more detail
Locked