Index: ssts-wash/src/main/java/com/forgon/disinfectsystem/washanddisinfectmanager/washanddisinfectrecord/dwr/table/WashAndDisinfectRecordTableManager.java =================================================================== diff -u -r37454 -r37456 --- ssts-wash/src/main/java/com/forgon/disinfectsystem/washanddisinfectmanager/washanddisinfectrecord/dwr/table/WashAndDisinfectRecordTableManager.java (.../WashAndDisinfectRecordTableManager.java) (revision 37454) +++ ssts-wash/src/main/java/com/forgon/disinfectsystem/washanddisinfectmanager/washanddisinfectrecord/dwr/table/WashAndDisinfectRecordTableManager.java (.../WashAndDisinfectRecordTableManager.java) (revision 37456) @@ -157,12 +157,9 @@ if(enableRinserGroupFunction){ String rinserGroupId = sqlWhereParamMap.get("rinserGroupId"); if(DatabaseUtil.isPoIdValid(rinserGroupId)){ - sql += String.format(" and (po.rinserId in (select id from %s where rinserGroupId = %s) or exists (select 1 from %s where id = %s and belongToAllOrgUnit = '%s'))", + sql += String.format(" and po.rinserId in (select id from %s where rinserGroupId = %s)", Rinser.class.getSimpleName(), - rinserGroupId, - RinserGroup.class.getSimpleName(), - rinserGroupId, - Constants.STR_YES); + rinserGroupId); } }