Index: ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/dwr/table/SterilizationRecordTableManager.java =================================================================== diff -u -r36385 -r36389 --- ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/dwr/table/SterilizationRecordTableManager.java (.../SterilizationRecordTableManager.java) (revision 36385) +++ ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/dwr/table/SterilizationRecordTableManager.java (.../SterilizationRecordTableManager.java) (revision 36389) @@ -221,7 +221,13 @@ + ")"; } boolean enableDoubleCheckOfSterilizationFunction = CssdUtils.getSystemSetConfigByNameBool("enableDoubleCheckOfSterilizationFunction", false); - + + List joinSql = parameterMap.get("parm_s_joinSql"); + if(joinSql == null){ + joinSql = new ArrayList(); + } + joinSql.add(" left join fetch po.verifier left join fetch po.reviewers "); + parameterMap.put("parm_s_joinSql", joinSql); if(enableDoubleCheckOfSterilizationFunction){ String verifierFullName = sqlWhereParamMap.get("verifier.fullName"); if(StringUtils.isNotBlank(verifierFullName)){