Searching for customer users using first name and surname

Hi,

Is it possible to search in OTRS for customer users in OTRS DB backend
using string build of first name + surname? I.e. you type

john black

in customer search field (i.e. in menu or customer search popup in
ticket create screen) and OTRS should find customer user with

  first name: John
  surname: Black
  <other not important here>

Standard OTRS uses

CustomerUserSearchFields => [ 'login', 'first_name', 'last_name',
'customer_id' ],

which doesn't work because it generates SQL for separate fields:

SELECT login , first_name, last_name, email FROM customer_user WHERE
((login LIKE '%john black%'  OR first_name LIKE '%john black%'  OR
last_name LIKE '%john black%'  OR customer_id LIKE '%john black%' ) )
LIMIT 50; 

Problem does not occur in LDAP backend with

CustomerUserSearchFields => ['sAMAccountName', 'cn', 'mail'],

because CN contains both first and surname concatenated.

We've tested that recunfiguring

CustomerUserSearchFields => [ 'login', 'first_name', 'last_name',
'customer_id', 'concat(first_name, " ", last_name)' ],

seems to work for MySQL DB queries but it's tricky and possibly may
cause problems if its not "official".

Is there any official solution for this kind of problem? Searching for
first name and surname together seems to be required for bigger systems
with lot of customer user records where separate searching for first
name or surname will return too many results.

-- 
Regards,
Pawel Boguslawski

IB Development Team
https://dev.ib.pl/




_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/mailman/listinfo/dev