Index: ssts-web/src/main/java/com/forgon/disinfectsystem/component/grid/GridManagerImpl.java =================================================================== diff -u -r13431 -r13443 --- ssts-web/src/main/java/com/forgon/disinfectsystem/component/grid/GridManagerImpl.java (.../GridManagerImpl.java) (revision 13431) +++ ssts-web/src/main/java/com/forgon/disinfectsystem/component/grid/GridManagerImpl.java (.../GridManagerImpl.java) (revision 13443) @@ -232,7 +232,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);