Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/action/JasperreportsAction.java =================================================================== diff -u -r20514 -r20726 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/action/JasperreportsAction.java (.../JasperreportsAction.java) (revision 20514) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/action/JasperreportsAction.java (.../JasperreportsAction.java) (revision 20726) @@ -982,7 +982,7 @@ + " i.type = '"+MaterialErrorDamageDetail.TYPE_DAMAGE+"' and i.operationTime between " + dateQueryAdapter.dateAdapter(startDay + " 00:00:00") + " and " + dateQueryAdapter.dateAdapter(endDay + " 23:59:59"); if(StringUtils.isNotBlank(departCoding)){ - sql += " and i.departCoding = '"+departCoding+"' "; + sql += " and i.departCode = '"+departCoding+"' "; } if(StringUtils.isNotBlank(goodsName)){ sql += " and i.materialName = '"+goodsName+"'";