Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java =================================================================== diff -u -r12974 -r12984 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java (.../TousseDefinitionManagerImpl.java) (revision 12974) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java (.../TousseDefinitionManagerImpl.java) (revision 12984) @@ -1903,7 +1903,9 @@ OrgUnit cssdOrgUnit,String spell) { String sql = "from " + TousseDefinition.class.getSimpleName() + " where id in (select tousseDefinitionId from " + CssdHandleTousses.class.getSimpleName() + " where orgUnitCode = '" + cssdOrgUnit.getOrgUnitCoding() + "')"; - sql += " and (spelling like '%" + spell + "%' or wbCode like '%" + spell + "%' or externalCode like '%" + spell + "%')"; + sql += " and (spelling like '%" + spell + "%' or wbCode like '%" + + spell + "%' or externalCode like '%" + spell + + "%' or name like '%" + spell + "%')"; return objectDao.findByHql(sql); }