Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java =================================================================== diff -u -r39134 -r39202 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java (.../TousseDefinitionManagerImpl.java) (revision 39134) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java (.../TousseDefinitionManagerImpl.java) (revision 39202) @@ -8385,7 +8385,7 @@ sql.append(TousseDefinitionNote.class.getSimpleName()); sql.append(" tn join "); sql.append(TousseDefinition.class.getSimpleName()); - sql.append(" td on td.id = tn.tousseDefinitionId where "); + sql.append(" td on td.id = tn.tousseDefinitionId where td.showTousseNote = '" + Constants.STR_YES + "' and "); sql.append(SqlUtils.getNonStringFieldInLargeCollectionsPredicate("td.id", tousseDefinitionIdList)); ResultSet rs = null; try {