Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/SterilizingStoveUseCountReportHelper.java =================================================================== diff -u -r37825 -r37856 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/SterilizingStoveUseCountReportHelper.java (.../SterilizingStoveUseCountReportHelper.java) (revision 37825) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/SterilizingStoveUseCountReportHelper.java (.../SterilizingStoveUseCountReportHelper.java) (revision 37856) @@ -419,7 +419,7 @@ + "' and sr.sterilizationResult in('" + SterilizationRecord.STERILIZATIONRESULT_QUALIFIED +"','"+ SterilizationRecord.STERILIZATIONRESULT_UNQUALIFIED - +"') or po.status='"+ SterilizationRecord.STERILIZATION_STATUS_INTERRUPT +"') "; + +"') or sr.status='"+ SterilizationRecord.STERILIZATION_STATUS_INTERRUPT +"') "; } String sterilizerNameGroupSql = SqlUtils.getWhereSqlByfilterFieldAndStringValueAndSeparator("s.ownGroup", sterilizerNameGroup, ","); String sterilizerNameSql = SqlUtils.getWhereSqlByfilterFieldAndStringValueAndSeparator("s.name", sterilizerName, ","); @@ -501,7 +501,7 @@ + "' and sr.sterilizationResult in('" + SterilizationRecord.STERILIZATIONRESULT_QUALIFIED +"','"+ SterilizationRecord.STERILIZATIONRESULT_UNQUALIFIED - +"') or po.status='"+ SterilizationRecord.STERILIZATION_STATUS_INTERRUPT +"') "; + +"') or sr.status='"+ SterilizationRecord.STERILIZATION_STATUS_INTERRUPT +"') "; } String sterilizerNameGroupSql = SqlUtils.getWhereSqlByfilterFieldAndStringValueAndSeparator("s.ownGroup", sterilizerNameGroup, ","); String sterilizerNameSql = SqlUtils.getWhereSqlByfilterFieldAndStringValueAndSeparator("s.name", sterilizerName, ",");