Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r29064 -r29244 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 29064) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 29244) @@ -13893,9 +13893,8 @@ }else if(QualityMonitoringDefinition.QUALITYMONITORING_MODULE_NAME_STERILIZATION.equals(responsibilityPart)){ String wdrStartDate = dateQueryAdapter.dateToVarchar1("sr.startDate"); extraQueryForResponsibilityPart = ",s.name,sr.frequency,sr.sterilizationUser,"+ wdrStartDate +" sterilizationStartDate,sr.amount steAmount "; - extraJoinForResponsibilityPart = " left join TousseInstance ti on ti.id=qmi.scanTousseInstance_id " - + " left join SterilizationRecord sr on sr.id=ti.sterilizationRecord_id " - + " left join Sterilizer s on s.id=sr.sterilizer_id "; + extraJoinForResponsibilityPart = " left join SterilizationRecord sr on sr.id=qmi.sterilizationRecordId " + + " left join Sterilizer s on s.id=sr.sterilizer_id "; } String extraQuery = ""; String extraJoin = "";