Index: ssts-wash/src/main/java/com/forgon/disinfectsystem/washanddisinfectmanager/washanddisinfectrecord/service/WashAndDisinfectRecordManagerImpl.java =================================================================== diff -u -r40907 -r40923 --- ssts-wash/src/main/java/com/forgon/disinfectsystem/washanddisinfectmanager/washanddisinfectrecord/service/WashAndDisinfectRecordManagerImpl.java (.../WashAndDisinfectRecordManagerImpl.java) (revision 40907) +++ ssts-wash/src/main/java/com/forgon/disinfectsystem/washanddisinfectmanager/washanddisinfectrecord/service/WashAndDisinfectRecordManagerImpl.java (.../WashAndDisinfectRecordManagerImpl.java) (revision 40923) @@ -7124,7 +7124,7 @@ Date endStartTime = new Date(date.getTime() + 10*60*1000); String beginStartTimeStr = ForgonDateUtils.safelyFormatDate(beginStartTime,ForgonDateUtils.SIMPLEDATEFORMAT_YYYYMMDDHHMMSS,""); String endStartTimeStr = ForgonDateUtils.safelyFormatDate(endStartTime,ForgonDateUtils.SIMPLEDATEFORMAT_YYYYMMDDHHMMSS,""); - queryString+=" and " + dateQueryAdapter.dateAreaSql("wd.date", beginStartTimeStr, endStartTimeStr, false); + queryString+=" and " + dateQueryAdapter.dateAreaSql("wd.startDate", beginStartTimeStr, endStartTimeStr, false); }else if(DeviceInterface.PARAMATCHINGMETHOD_ENDDATE.equals(deviceInterface.getParaMatchingMethod())){ Date beginEndTime = new Date(date.getTime() - 10*60*1000); Date endEndTime = new Date(date.getTime() + 10*60*1000);