Unable to see customerids field in customerusers table

Moderator: crythias

Post Reply
rani+bandaru
Znuny newbie
Posts: 37
Joined: 10 Jun 2010, 11:33
Znuny Version: 2.2.7

Unable to see customerids field in customerusers table

Post by rani+bandaru »

Hi

I am working as Dev in a QLogy. I implemented OTRS in our organisation. I read documentation.It is working fine.

I added a customer_ids field to customer_user table from backend as following steps:


mysql> use otrs;

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
Bye
linux:~#


Added the new column to the MAP array in Kernel/Config.pm:

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


saved the file and restarted the server


Now the problem is i can see the field through backend with a null value in it to all the customers but from frontend i.e., from admin area there no such field visible at all.
How can i make it visible through frontend.?
How can trace the process?
Do i have to do any more settings or changes?
Please guide me.

Regards,
rani
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Unable to see customerids field in customerusers table

Post by crythias »

You'll want to add the field in the appropriate .dtl. in the theme in order to show it, generally.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Post Reply