Currently, the user search provided by the search plugin takes the search value provided through ‘‘name’’ as a case sensitive value. This is quite annoying. Searching for the name ‘‘guus’’ should also return users that have set their name as ‘‘Guus’’
The search plugin seems to be limited in its search by the UserProvider interface. It defines two a case sensitive findUsers() methods. Is there a way to make these searches case insensitive?
Most (if not all) DBMSses support the LOWER(string) function. Adjusting the search queries from somthing like
... WHERE name LIKE ''").append(StringUtils.escapeForSQL(query)).append("''");
... WHERE LOWER(name) LIKE ''").append(StringUtils.escapeForSQL(query.toLowerCase())).append("''");
could improve functionality for SQL-backed user providers.
Can something similar work for the LDAP provider as well?