Create a dynamic field as a customer field

Moderator: crythias

Locked
sg23
Znuny newbie
Posts: 11
Joined: 19 Nov 2013, 12:35
Znuny Version: 3.2.8
Real Name: Sebastian

Create a dynamic field as a customer field

Post by sg23 »

Hi,

is it possible to create a dynamic field as a second (or third, ...) customer field?

How would you fill the dynamic field with customer entrys?

Any ideas? :o
- OTRS 3.2.8
- ITSM 3.2.9
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Create a dynamic field as a customer field

Post by crythias »

For the customer table, you can simply (ahem) alter the customer_user table
ALTER TABLE `customer_user` ADD `my_custom_field` VARCHAR( 200 ) NULL;

and then modify the CustomerUser Map in Config.pm to reflect the additional fields.
prepending "my_" will reasonably guarantee your columns won't conflict with OTRS columns in the future.
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
Locked