Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java
===================================================================
diff -u -r29688 -r29696
--- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java	(.../TousseDefinitionManagerImpl.java)	(revision 29688)
+++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseDefinitionManagerImpl.java	(.../TousseDefinitionManagerImpl.java)	(revision 29696)
@@ -3307,7 +3307,7 @@
 			comboTousseOrgUnitCodingSql = String.format(" and po.id in(select comboTousseDefinitionId from %s where unitCode='%s')", ComboTousseOrgUint.class.getSimpleName(),comboTousseOrgUnitCoding);
 		}else{
 			if(CollectionUtils.isNotEmpty(departCodes)){
-				comboTousseOrgUnitCodingSql = SqlUtils.getStringFieldInLargeCollectionsPredicate("ctou.unitCode", departCodes);
+				comboTousseOrgUnitCodingSql = " and " + SqlUtils.getStringFieldInLargeCollectionsPredicate("ctou.unitCode", departCodes);
 			}
 			joinComboTousseOrgUint = " ,ComboTousseOrgUint ctou ";
 			selComboTousseOrgUint = " ,ctou.unitCode ";