Index: webapp/WEB-INF/src/org/olat/basesecurity/PersistingManager.java =================================================================== RCS file: /usr/local/cvs/olat3/webapp/WEB-INF/src/org/olat/basesecurity/PersistingManager.java,v retrieving revision 1.55 diff -u -r1.55 PersistingManager.java --- webapp/WEB-INF/src/org/olat/basesecurity/PersistingManager.java 7 Feb 2006 18:10:19 -0000 1.55 +++ webapp/WEB-INF/src/org/olat/basesecurity/PersistingManager.java 13 Jun 2006 12:04:46 -0000 @@ -729,37 +729,37 @@ if (login != null) { login = makeFuzzyQueryString(login); needsAnd = true; - sb.append(" ident.name like :login "); + sb.append(" lower(ident.name) like :login "); } if (first != null) { first = makeFuzzyQueryString(first); if (needsAnd) sb.append(" and "); needsAnd = true; - sb.append(" ident.user.firstName like :first "); + sb.append(" lower(ident.user.firstName) like :first "); } if (last != null) { last = makeFuzzyQueryString(last); if (needsAnd) sb.append(" and "); needsAnd = true; - sb.append(" ident.user.lastName like :last "); + sb.append(" lower(ident.user.lastName) like :last "); } if (email != null) { email = makeFuzzyQueryString(email); if (needsAnd) sb.append(" and "); needsAnd = true; - sb.append(" (ident.user.email like :email or ident.user.institutionalEmail like :email)"); + sb.append(" (lower(ident.user.email) like :email or lower(ident.user.institutionalEmail) like :email)"); } if (inst != null) { inst = makeFuzzyQueryString(inst); if (needsAnd) sb.append(" and "); needsAnd = true; - sb.append(" ident.user.institutionalName like :inst "); + sb.append(" lower(ident.user.institutionalName) like :inst "); } if (instId != null) { instId = makeFuzzyQueryString(instId); if (needsAnd) sb.append(" and "); needsAnd = true; - sb.append(" ident.user.institutionalUserIdentifier like :instId "); + sb.append(" lower(ident.user.institutionalUserIdentifier) like :instId "); } // append query for named security groups @@ -831,17 +831,17 @@ // add user attributes if (login != null) - dbq.setString("login", login); + dbq.setString("login", login.toLowerCase()); if (first != null) - dbq.setString("first", first); + dbq.setString("first", first.toLowerCase()); if (last != null) - dbq.setString("last", last); + dbq.setString("last", last.toLowerCase()); if (email != null) - dbq.setString("email", email); + dbq.setString("email", email.toLowerCase()); if (inst != null) - dbq.setString("inst", inst); + dbq.setString("inst", inst.toLowerCase()); if (instId != null) - dbq.setString("instId", instId); + dbq.setString("instId", instId.toLowerCase()); // add named security group names if (hasGroups) { Index: webapp/WEB-INF/src/org/olat/repository/RepositoryManager.java =================================================================== RCS file: /usr/local/cvs/olat3/webapp/WEB-INF/src/org/olat/repository/RepositoryManager.java,v retrieving revision 1.58 diff -u -r1.58 RepositoryManager.java --- webapp/WEB-INF/src/org/olat/repository/RepositoryManager.java 23 Feb 2006 17:32:15 -0000 1.58 +++ webapp/WEB-INF/src/org/olat/repository/RepositoryManager.java 13 Jun 2006 12:04:46 -0000 @@ -379,7 +379,7 @@ query.append("sgmsi.securityGroup = v.ownerGroup and "+ "sgmsi.identity = identity and "+ "identity.user = user and "+ - "(user.firstName like :author or user.lastName like :author or identity.name like :author)"); + "(lower(user.firstName) like :author or lower(user.lastName) like :author or lower(identity.name) like :author)"); previousWhere = true; } @@ -387,7 +387,7 @@ displayName = displayName.replace('*','%'); displayName = '%' + displayName + '%'; if (previousWhere) query.append(" and "); - query.append("v.displayname like :displayname"); + query.append("lower(v.displayname) like :displayname"); previousWhere = true; } @@ -395,7 +395,7 @@ desc = desc.replace('*','%'); desc = '%' + desc + '%'; if (previousWhere) query.append(" and "); - query.append("v.description like :desc"); + query.append("lower(v.description) like :desc"); previousWhere = true; } @@ -416,13 +416,13 @@ DBQuery dbQuery = DB.getInstance().createQuery(query.toString()); if (var_author) { - dbQuery.setString("author", author); + dbQuery.setString("author", author.toLowerCase()); } if (var_displayname) { - dbQuery.setString("displayname", displayName); + dbQuery.setString("displayname", displayName.toLowerCase()); } if (var_desc) { - dbQuery.setString("desc", desc); + dbQuery.setString("desc", desc.toLowerCase()); } if (var_resourcetypes) { dbQuery.setParameterList("resourcetypes", resourceTypes, Hibernate.STRING);