Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/DataIndex.java =================================================================== diff -u -r36660 -r36904 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/DataIndex.java (.../DataIndex.java) (revision 36660) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/DataIndex.java (.../DataIndex.java) (revision 36904) @@ -2458,7 +2458,7 @@ + "on fi.formDefinition_id = fd.id join QualityMonitoringDefinition qmdf on qmdf.id=fd.id inner join QualityMonitoringGoods qmd on qi.id=qmd.qualityMonitoringInstance_id " + "inner join FormInstanceItem fii on fi.id = fii.formInstance_id " + "inner join FormDefinitionItem fdi on fii.formDefinitionItem_id = fdi.id " - + "where fii.answer like '%%" + likeValue + "%%' " + + "where fd.formName like '%%" + likeValue + "%%' " + "and qi.datetime %s %s and fd.formType = '质量监测'" + "group by " + obj.monthlyStr,