Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/RealTimeBulletinBoardWorkloadHelper.java =================================================================== diff -u -r36121 -r36126 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/RealTimeBulletinBoardWorkloadHelper.java (.../RealTimeBulletinBoardWorkloadHelper.java) (revision 36121) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/RealTimeBulletinBoardWorkloadHelper.java (.../RealTimeBulletinBoardWorkloadHelper.java) (revision 36126) @@ -915,6 +915,7 @@ +" pd on pd.id=ti.proxyDisinfection_id where tdancestor.isTraceable='是' and ti.status='" + TousseInstance.STATUS_REVIEWED +"' " + + SqlUtils.buildFieldNameBetweenSql("ti.operationTime", toBeBetweenSql) + tousseTypesql + "and ti.comboTousseInstanceId is null and ti.reviewBasket_id is null and (pd.id is null and ti.orgunitcoding='" +handleDepartCoding