Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r18094 -r18108 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 18094) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 18108) @@ -15321,7 +15321,7 @@ + "join TousseItem ti on ti.recyclingApplication_ID=rr.recyclingApplication_id " + "left join TousseTransitionRecord ttr on ttr.recyclingApplicationId=rr.recyclingApplication_id " + "left join TousseTransitionItem tti on tti.tousseTransitionRecordId=ttr.id " - + "left join WashTransitionItem wti on wti.idCardBarcode=tti.idCardInstanceBarcode " + + "left join WashTransitionItem wti on wti.tousseBarcode=tti.tousseBarcode " + "left join WashTransitionRecord wtr on wtr.id=wti.washTransitionRecordId " + "left join TousseInstance tin on tin.recyclingRecordId=rr.id " + "left join barcodeDevice bd on bd.id=tin.id "