Index: ssts-qualitymon/src/main/java/com/forgon/disinfectsystem/qualitymonitoring/definition/service/QualityControlItemParameterManagerImpl.java =================================================================== diff -u -r40973 -r40978 --- ssts-qualitymon/src/main/java/com/forgon/disinfectsystem/qualitymonitoring/definition/service/QualityControlItemParameterManagerImpl.java (.../QualityControlItemParameterManagerImpl.java) (revision 40973) +++ ssts-qualitymon/src/main/java/com/forgon/disinfectsystem/qualitymonitoring/definition/service/QualityControlItemParameterManagerImpl.java (.../QualityControlItemParameterManagerImpl.java) (revision 40978) @@ -155,9 +155,9 @@ if(StringUtils.isNotBlank(spell)){ sqlBuffer.append(" and (name like '%"); sqlBuffer.append(spell); - sqlBuffer.append("%' or qualityControlIndicatorType.name like '%"); + sqlBuffer.append("%' or id in (select id from QualityControlItemParameter where qualityControlIndicatorType.name like '%"); sqlBuffer.append(spell); - sqlBuffer.append("%')"); + sqlBuffer.append("%'))"); } int count = objectDao.countObjectBySql(QualityControlItemParameter.class.getSimpleName(), sqlBuffer.toString()); page.setCount(count);