[SOLVED] Customer search customization

Moderator: crythias

Locked
dolfiz
Znuny newbie
Posts: 85
Joined: 15 Jan 2014, 21:07
Znuny Version: 3.3.3
Location: Italy

[SOLVED] Customer search customization

Post by dolfiz »

Hi all,

we've got two issues to solve about customer search:

1) limit the lookup search not to 2 characters as the deafult is (we've got a customer master data of over 700k entries and we want that the db query is run only after at least 4-5 characters, to limits results)
2) show more information in the ajax lookup after the query is ran (we need to show also custom columns that we add to CUSTOMER_USER table)

A third issue is the column over the search query is run, but we found this topic that should help: http://lists.otrs.org/pipermail/otrs/20 ... 03645.html

Hope someone has hints about the first two problems ;)

Thanks,
Luca
Last edited by dolfiz on 21 Jan 2014, 20:50, edited 1 time in total.
OTRS 3.3.3 - Ubuntu server 12.04 - MySQL
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Customer search customization

Post by crythias »

1) Sysconfig AutoComplete::Agent###CustomerSearch
MinQueryLength (Search for this word in sysconfig)

2) Kernel/Config.pm
CustomerUserListFields => [ 'first_name', 'last_name', 'email' ],
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
dolfiz
Znuny newbie
Posts: 85
Joined: 15 Jan 2014, 21:07
Znuny Version: 3.3.3
Location: Italy

Re: [SOLVED] Customer search customization

Post by dolfiz »

Thank you very much crythias! ;)

In order to help others on the same topic...

As crythias said, on Config.pm (from Defaults.pm examples):

CustomerUserListFields -> Fields showed during customer lookup search
CustomerUserSearchFields -> Fields over the search is run
OTRS 3.3.3 - Ubuntu server 12.04 - MySQL
Locked