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.66 diff -u -r1.66 PersistingManager.java --- webapp/WEB-INF/src/org/olat/basesecurity/PersistingManager.java 13 Jul 2006 08:47:29 -0000 1.66 +++ webapp/WEB-INF/src/org/olat/basesecurity/PersistingManager.java 24 Jul 2006 09:51:07 -0000 @@ -754,37 +754,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 @@ -856,17 +856,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.67 diff -u -r1.67 RepositoryManager.java --- webapp/WEB-INF/src/org/olat/repository/RepositoryManager.java 6 Jul 2006 16:32:00 -0000 1.67 +++ webapp/WEB-INF/src/org/olat/repository/RepositoryManager.java 24 Jul 2006 09:51:10 -0000 @@ -393,7 +393,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; } @@ -401,7 +401,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; } @@ -409,7 +409,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; } @@ -430,13 +430,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);