Index: ssts-operationmonitor/src/main/java/com/forgon/disinfectsystem/supplyroomcontrol/service/WdRoomControlHelper.java =================================================================== diff -u -r28409 -r28419 --- ssts-operationmonitor/src/main/java/com/forgon/disinfectsystem/supplyroomcontrol/service/WdRoomControlHelper.java (.../WdRoomControlHelper.java) (revision 28409) +++ ssts-operationmonitor/src/main/java/com/forgon/disinfectsystem/supplyroomcontrol/service/WdRoomControlHelper.java (.../WdRoomControlHelper.java) (revision 28419) @@ -75,7 +75,7 @@ if (TousseDefinition.PACKAGE_TYPE_DISINFECTION.equals(tousseType)) { tousseNameSql = " and (ci.tousseNameForMaterial like '%" + tousseName + "%' or (td.tousseType = '" + TousseDefinition.PACKAGE_TYPE_DISINFECTION + "' and ci.name = '" + tousseName + "'))"; }else { - tousseNameSql = " and td.name = '" + tousseName + "'"; + tousseNameSql = " and ci.name = '" + tousseName + "'"; } } String taskGroupSql = "";