[SOLVED] Search - Customer User

[abelic]

Hi,

Can somebody help me with customer user search, using wildcards?

I want a list of customers with a specific domain. @xxxxxx.com

Thanks,


Kind regards,
Sasha

[alexus]

Hi,

Where you make a search? InIn which interface you are searching?

[abelic]

Hi Alexey,

In "Manage Customer-Services Relations" search field.

[skullz]

try

Code: Select all

*@gmail.com

[abelic]

Hi,

Already tried that. Doesn't work.

[abelic]

Hmm, it looks like you can't search for <xxx@xxx.xxx> even though the email address is visible on the screen. Search is possible only by first and last name. Am I right?

[root]

Hi,

It's using the field you have configured in the parameter CustomerUserSearchFields for your configured backends. If you're using the default settings the e-mail is not included. Copy the he configuration to Kernel/Config.pm and add the field to the parameter.

- Roy

[crythias]

Probably not recommended, but if the Customer_Users are all in the database, pop this in SQL Box:

Code: Select all

SELECT * FROM customer_user where email like "%@gmail.com"

[abelic]

Hi,

I think Roy is right. We need to configure config.pm. Because it is the only right solution for our needs to easily connect the service with specific customers in the section "Manage Customer-Services Relations".

The Crythias solution gave us the best manual solution at this point.

Thank you for your help, I appreciate it.

Kind regards,
Sasha

[skullz]

As an additional point on roy suggestion, you can directly modify $otrs_home/Kernel/Config/Defaults.pm (not suggested as it will be overwrite upon upgrade/patch level, but should work)

The, perhaps restart webserver.

Code: Select all

(-) CustomerUserSearchFields           => [ 'login', 'first_name', 'last_name', 'customer_id' ],
(+) CustomerUserSearchFields           => [ 'login', 'first_name', 'last_name', 'customer_id', 'email' ],

[root]

Sorry to interrupt.

Never, never, never modify the Defaults.pm

Always copy the required part(s) to Kernel/Config.pm

- Roy

[abelic]

Hi,

I understood and accepted. When I have time, I will try to configure config.pm as you suggested to me in the test environment and see how it works.

Thank you!

Sasha