Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/barcode/dwr/table/BarcodeTableManager.java =================================================================== diff -u -r13425 -r13446 --- ssts-basedata/src/main/java/com/forgon/disinfectsystem/barcode/dwr/table/BarcodeTableManager.java (.../BarcodeTableManager.java) (revision 13425) +++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/barcode/dwr/table/BarcodeTableManager.java (.../BarcodeTableManager.java) (revision 13446) @@ -240,7 +240,7 @@ */ private String getTousseTaskGroupByOrgUnitCode(TousseDefinition td, String orgUnitCoding){ String taskGroup = td.getTaskGroup(); - String sql = "select ct.taskGroup from CssdHandleTousses ct where ct.tousseDefinitionId = " + td.getId(); + String sql = "select ct.taskGroup from CssdHandleTousses ct where ct.tousseDefinitionId = " + td.getId() + " and orgUnitCode = '" + orgUnitCoding + "'"; ResultSet rs = null; try{ rs = objectDao.executeSql(sql);