User search broken if an ldap user has no first, last name or email entry

[hi-ko]

It's an Alfresco bug since years but since I trapped into that issue again we should try to fix it:

If a user is synced from ldap without a property expected by the user list in Admin-tools none of the users will be listed.

research so far:
issue occurs if canned query is beeing used

https://github.com/ecm4u/alfresco-ce-repository/blob/44830aeeb05d180b4c4e132292e009dbb9fe80f2/root/projects/repository/source/java/org/alfresco/repo/domain/query/ibatis/CannedQueryDAOImpl.java#L26

SQL debugging needs to be set up to digg deeper:
https://community.alfresco.com/message/741409-re-sql-query-debug?commentID=741409#comment-741409

[hi-ko]

the query: https://github.com/ecm4u/alfresco-ce-repository/blob/342240e82dd28a89ebc7ca52f0e60093261e789f/root/projects/repository/config/alfresco/ibatis/org.hibernate.dialect.Dialect/query-people-common-SqlMap.xml#L13