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/
participants (1)
-
IB Development Team