[SOLVED] Dynamic filed database filled with customers

[Sayannara]

Hello

I am able to use a dynamic field, database type, to fill values with agents as I can get them from the users table of my OTRS DB. I would do the same with customers but my tables are empty.

customer_user
customer_user_customer

Should I change my Config.pm to sync them? They currently log in with LDAP auth and everything is working.

Any suggestion to accomplish this?

It looks that it used to be a specific customer type-field:
https://www.youtube.com/watch?v=ZdTlIld7hyE

Thanks a lot for your help.

[wurzel]

Hi,

if you have all customer users in LDAP, they are not stored in local database. So customer_user table is empty.

I would not sync them. I assume you are using OTRS (OTRS Business Solution)? There is a feature for dynamic fields type customer. This could help you.

Florian

[Sayannara]

Here is the feature
https://otrs.com/otrs-feature/feature-a ... ct-fields/

I decided to create a database otrs_data and with PowerShell I'll populate my own customers table every day.

Thank you.

[wurzel]

Hi,

if you do so, do not forget to clean caches.

Flo

[Sayannara]

uh ?

Clean caches of MYSQL? Or OTRS?

Thank you

[wurzel]

Hi,

any manual changes in the OTRS DB require a Maint::Cache::Delete

Flo

[Sayannara]

Okay thank you.

Actually I created on the local server a second database otrs_data to not change the default database so everything is fine.