Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/SupplyRoomQualityQuotaHelper.java =================================================================== diff -u -r41163 -r41164 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/SupplyRoomQualityQuotaHelper.java (.../SupplyRoomQualityQuotaHelper.java) (revision 41163) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/SupplyRoomQualityQuotaHelper.java (.../SupplyRoomQualityQuotaHelper.java) (revision 41164) @@ -2614,9 +2614,9 @@ sql.append(" join " + FormInstanceItem.class.getSimpleName() +" fii on fii.formInstance_id=fi.id " + " join " + FormInstanceOptionValue.class.getSimpleName() +" fiov on fiov.formInstanceItem_id=fii.id "); if(tousse){ - sql.append(" join "+ FormOptionTousseGoods.class.getSimpleName() +" fotg on fotg.formOptionValue_id=fiov.id "); + sql.append(" join "+ FormOptionTousseGoods.class.getSimpleName() +" fotg on fotg.formOptionValueId=fiov.id "); }else{ - sql.append(" join "+ FormOptionMaterialGoods.class.getSimpleName() +" fomg on fomg.formOptionValue_id=fiov.id "); + sql.append(" join "+ FormOptionMaterialGoods.class.getSimpleName() +" fomg on fomg.formOptionValueId=fiov.id "); } } sql.append(" where fd.formType = '");