Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/reportforms/service/ReportManagerImpl.java =================================================================== diff -u -r33840 -r33841 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/reportforms/service/ReportManagerImpl.java (.../ReportManagerImpl.java) (revision 33840) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/reportforms/service/ReportManagerImpl.java (.../ReportManagerImpl.java) (revision 33841) @@ -621,7 +621,7 @@ + "' and sr.sterilizationResult in('" + SterilizationRecord.STERILIZATIONRESULT_QUALIFIED +"','"+ SterilizationRecord.STERILIZATIONRESULT_UNQUALIFIED - +"' "; + +"') "; } String sterilizerNameGroupSql = SqlUtils.getWhereSqlByfilterFieldAndStringValueAndSeparator("s.ownGroup", sterilizerNameGroup, ","); String sterilizerNameSql = SqlUtils.getWhereSqlByfilterFieldAndStringValueAndSeparator("s.name", sterilizerName, ","); @@ -701,7 +701,7 @@ + "' and sr.sterilizationResult in('" + SterilizationRecord.STERILIZATIONRESULT_QUALIFIED +"','"+ SterilizationRecord.STERILIZATIONRESULT_UNQUALIFIED - +"' "; + +"') "; } String sterilizerNameGroupSql = SqlUtils.getWhereSqlByfilterFieldAndStringValueAndSeparator("s.ownGroup", sterilizerNameGroup, ","); String sterilizerNameSql = SqlUtils.getWhereSqlByfilterFieldAndStringValueAndSeparator("s.name", sterilizerName, ","); Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r33840 -r33841 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 33840) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 33841) @@ -13065,7 +13065,7 @@ + "' and po.sterilizationResult in('" + SterilizationRecord.STERILIZATIONRESULT_QUALIFIED +"','"+ SterilizationRecord.STERILIZATIONRESULT_UNQUALIFIED - +"' "; + +"') "; } String sql = " where po.endDate between " + dateQueryAdapter.dateConverAdapter2( startTime