Index: ssts-web/src/main/java/com/forgon/disinfectsystem/systemwarning/service/SystemWarningManagerImpl.java =================================================================== diff -u -r36681 -r37853 --- ssts-web/src/main/java/com/forgon/disinfectsystem/systemwarning/service/SystemWarningManagerImpl.java (.../SystemWarningManagerImpl.java) (revision 36681) +++ ssts-web/src/main/java/com/forgon/disinfectsystem/systemwarning/service/SystemWarningManagerImpl.java (.../SystemWarningManagerImpl.java) (revision 37853) @@ -327,7 +327,7 @@ String sql = String.format("select count(1) from %s rr " + "join %s rri on rri.recallRecord_id = rr.id " + "join %s ti on rri.id = ti.recallRecordItem_id " - + "where rr.status = '%s' %s ", + + "where ti.status='"+ TousseInstance.STATUS_WAIT_FOR_RECALL +"' and rr.status = '%s' %s ", RecallRecord.class.getSimpleName(), RecallRecordItem.class.getSimpleName(), TousseInstance.class.getSimpleName(),