Author: kmorin Date: 2014-10-17 15:20:48 +0200 (Fri, 17 Oct 2014) New Revision: 679 Url: http://forge.codelutin.com/projects/faxtomail/repository/revisions/679 Log: refs #5939 Page web de recherche des ?\195?\169l?\195?\169ments archiv?\195?\169s Modified: trunk/faxtomail-persistence/src/main/java/com/franciaflex/faxtomail/persistence/entities/EmailTopiaDao.java Modified: trunk/faxtomail-persistence/src/main/java/com/franciaflex/faxtomail/persistence/entities/EmailTopiaDao.java =================================================================== --- trunk/faxtomail-persistence/src/main/java/com/franciaflex/faxtomail/persistence/entities/EmailTopiaDao.java 2014-10-17 12:29:12 UTC (rev 678) +++ trunk/faxtomail-persistence/src/main/java/com/franciaflex/faxtomail/persistence/entities/EmailTopiaDao.java 2014-10-17 13:20:48 UTC (rev 679) @@ -484,8 +484,8 @@ query.append(newFromClause("E") + " WHERE E." + Email.PROPERTY_MAIL_FOLDER + " in (:folders)"); args.put("folders", folders); -// query.append(" AND E." + Email.PROPERTY_DEMAND_STATUS + " = :archiveStatus"); -// args.put("archiveStatus", DemandStatus.ARCHIVED); + query.append(" AND E." + Email.PROPERTY_DEMAND_STATUS + " = :archiveStatus"); + args.put("archiveStatus", DemandStatus.ARCHIVED); query.append(" AND (EXISTS (FROM " + RangeRow.class.getName() + " RR WHERE RR in elements(E." + Email.PROPERTY_RANGE_ROW + ")"); query.append(" AND lower(RR." + RangeRow.PROPERTY_COMMAND_NUMBER + ") LIKE lower(:" + SearchFilter.PROPERTY_COMMAND_NB + "))");