Hi Syoxx,

That’s not true, I’m sure it’s possible. ;)

You need to add the dynamic field info to the $Self->{CustomerCompany} mapping in Kernel/Config.pm. If this option does not already exist in Kernel/Config.pm, you need copy the entire option from Kernel/Config/Defaults.pm to Kernel/Config.pm:

    $Self->{CustomerCompany} = {

        Name   => Translatable(‚Database Backend‘),

        Module => ‚Kernel::System::CustomerCompany::DB‘,

.. More Content …

        Map => [

            # Info about dynamic fields:

            #

            # Dynamic Fields of type CustomerCompany can be used within the mapping (see example below).

            # The given storage (third column) then can also be used within the following configurations (see above):

            # CustomerCompanySearchFields, CustomerCompanyListFields

            #

            # Note that the columns ‚frontend‘ and ‚readonly‘ will be ignored for dynamic fields.

            # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly

            [ ‚CustomerID‘,             ‚CustomerID‘, ‚customer_id‘, 0, 1, ‚var‘, “, 0 ],

            [ ‚CustomerCompanyName‘,    ‚Customer‘,   ’name‘,        1, 1, ‚var‘, “, 0 ],

            [ ‚CustomerCompanyStreet‘,  ‚Street‘,     ’street‘,      1, 0, ‚var‘, “, 0 ],

            [ ‚CustomerCompanyZIP‘,     ‚Zip‘,        ‚zip‘,         1, 0, ‚var‘, “, 0 ],

            [ ‚CustomerCompanyCity‘,    ‚City‘,       ‚city‘,        1, 0, ‚var‘, “, 0 ],

            [ ‚CustomerCompanyCountry‘, ‚Country‘,    ‚country‘,     1, 0, ‚var‘, “, 0 ],

            [ ‚CustomerCompanyURL‘,     ‚URL‘,        ‚url‘,         1, 0, ‚var‘, ‚[% Data.CustomerCompanyURL | html %]‘, 0 ],

            [ ‚CustomerCompanyComment‘, ‚Comment‘,    ‚comments‘,    1, 0, ‚var‘, “, 0 ],

            [ ‚ValidID‘,                ‚Valid‘,      ‚valid_id‘,    0, 1, ‚int‘, “, 0 ],

            # Dynamic field example

#            [ ‚DynamicField_Name_Y‘, undef, ‚Name_Y‘, 0, 0, ‚dynamic_field‘, undef, 0 ],

        ],

    };

 

After that you are able to configure your dynamic fields. Please add the following information to the mapping for each field:

            [ ‚DynamicField_Name_Y‘, undef, ‚Name_Y‘, 0, 0, ‚dynamic_field‘, undef, 0 ],

 

Another possibility is to extend the database table and don’t use a dynamic field:

For MySQL or MariaDB:

root> mysql -uroot otrs

root> ALTER TABLE customercompany add NameOfNewColumn VARCHAR(255);

After that add a new value to the mapping above:

  [ ‚CustomerCompanyNameOfNewColumn‘, ‚LabelOfNewColumn‘,    ‚NameOfNewColumn‘,    1, 0, ‚var‘, “, 0 ],

I hope I could help. Please do not hesitate to contact us if you have any questions.

Best regards from Germany,

Stefan

Team OTOBO

You’re welcome, have fun with OTOBO!