Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/dwr/table/TousseDefinitionTableManager.java
===================================================================
diff -u -r26240 -r26698
--- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/dwr/table/TousseDefinitionTableManager.java	(.../TousseDefinitionTableManager.java)	(revision 26240)
+++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/dwr/table/TousseDefinitionTableManager.java	(.../TousseDefinitionTableManager.java)	(revision 26698)
@@ -132,7 +132,7 @@
 				if(SupplyRoomConfig.SUPPLYROOM_TYPE_FIRST_SUPPLYROOM == roomType){
 					String sqlBelongDepartIsBlank = String.format(" po.id not in ( select tousseDefinitionId from %s )",
 							TousseDefinitionBelongDepart.class.getSimpleName());
-					sql += String.format(" and (( %s ) or ( %s )))",filterCode,sqlBelongDepartIsBlank);
+					sql += String.format(" and (( %s ) or ( %s ))",filterCode,sqlBelongDepartIsBlank);
 				}else{
 					sql += String.format(" and( %s )",filterCode);
 				}