Customer with Multiple IDs

Moderator: crythias

Post Reply
OTRS newbie
Posts: 11
Joined: 05 Jul 2017, 21:17
OTRS Version?: 5.0.20
Real Name: Kristoffel Loos
Company: Telecom IT

Customer with Multiple IDs

Post by kloos » 17 Nov 2017, 15:37


I'm looking to how to enable multiple IDs for my customer users, I created the ne column in the customer_user table in the OTRS database as discribed in the user manual:

linux:~# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 124 to server version: 5.0.18-Debian_7-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use otrs;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> ALTER TABLE customer_user ADD customer_ids VARCHAR (250);
Query OK, 1 rows affected (0.02 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> quit

Now the new column has to be added to the MAP array in Kernel/, as shown
in the script below:

# var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link,
readonly, http-link-target, link class(es)
[ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ],

I don't get what need to be done here now, this script needs to be run how?



Post Reply