[SOLVED] Search - Customer User

Moderator: crythias

Post Reply
abelic
Znuny newbie
Posts: 24
Joined: 30 Jun 2017, 17:07
Znuny Version: 6.4
Real Name: Aleksandar Belic
Company: CP

[SOLVED] Search - Customer User

Post by 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
Last edited by abelic on 18 Mar 2021, 23:34, edited 2 times in total.
Znuny 6.4, CentOS7, MariaDB
alexus
Znuny wizard
Posts: 380
Joined: 20 Sep 2010, 16:54
Znuny Version: OTRS 6 CE
Real Name: Alexey Yusov
Company: Radiant System Group s.r.o
Location: Prague
Contact:

Re: Search - Customer User

Post by alexus »

Hi,

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

Production: OTRS CE ITSM 6.0.28 on CentOS 7 + Apache 2.4 + MariaDB 10.4.13 + Radiant Customer Portal

Radiant System OTRS Intergrator
RS4OTRS marketplace
Stay tuned on our Facebook
((OTRS)) Community Edition - what next?
abelic
Znuny newbie
Posts: 24
Joined: 30 Jun 2017, 17:07
Znuny Version: 6.4
Real Name: Aleksandar Belic
Company: CP

Re: Search - Customer User

Post by abelic »

Hi Alexey,

In "Manage Customer-Services Relations" search field.
Znuny 6.4, CentOS7, MariaDB
skullz
Znuny superhero
Posts: 618
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Search - Customer User

Post by skullz »

try

Code: Select all

*@gmail.com
abelic
Znuny newbie
Posts: 24
Joined: 30 Jun 2017, 17:07
Znuny Version: 6.4
Real Name: Aleksandar Belic
Company: CP

Re: Search - Customer User

Post by abelic »

Hi,

Already tried that. Doesn't work. :(
Znuny 6.4, CentOS7, MariaDB
abelic
Znuny newbie
Posts: 24
Joined: 30 Jun 2017, 17:07
Znuny Version: 6.4
Real Name: Aleksandar Belic
Company: CP

Re: Search - Customer User

Post by 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?
Znuny 6.4, CentOS7, MariaDB
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Search - Customer User

Post by 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
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Search - Customer User

Post by 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"
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
abelic
Znuny newbie
Posts: 24
Joined: 30 Jun 2017, 17:07
Znuny Version: 6.4
Real Name: Aleksandar Belic
Company: CP

Re: Search - Customer User

Post by 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
Znuny 6.4, CentOS7, MariaDB
skullz
Znuny superhero
Posts: 618
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: [SOLVED] Search - Customer User

Post by 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
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: [SOLVED] Search - Customer User

Post by root »

Sorry to interrupt.

Never, never, never modify the Defaults.pm

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

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
abelic
Znuny newbie
Posts: 24
Joined: 30 Jun 2017, 17:07
Znuny Version: 6.4
Real Name: Aleksandar Belic
Company: CP

Re: [SOLVED] Search - Customer User

Post by 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
Znuny 6.4, CentOS7, MariaDB
Post Reply