Author: fdesbois Date: 2010-02-05 18:25:46 +0000 (Fri, 05 Feb 2010) New Revision: 332 Modified: trunk/suiviobsmer-business/src/main/java/fr/ifremer/suiviobsmer/impl/ServiceSynthesisImpl.java Log: Use BETWEEN instead of <= and >= in query Modified: trunk/suiviobsmer-business/src/main/java/fr/ifremer/suiviobsmer/impl/ServiceSynthesisImpl.java =================================================================== --- trunk/suiviobsmer-business/src/main/java/fr/ifremer/suiviobsmer/impl/ServiceSynthesisImpl.java 2010-02-05 18:10:00 UTC (rev 331) +++ trunk/suiviobsmer-business/src/main/java/fr/ifremer/suiviobsmer/impl/ServiceSynthesisImpl.java 2010-02-05 18:25:46 UTC (rev 332) @@ -357,11 +357,9 @@ String tideBeginDateKey = contactKey + "." + Contact.TIDE_BEGIN_DATE; String createDateKey = contactKey + "." + TopiaEntity.TOPIA_CREATE_DATE; query.add("(" + tideBeginDateKey + " IS NOT NULL " + - "AND " + tideBeginDateKey + " >= :fromDate " + - "AND " + tideBeginDateKey + " <= :thruDate)" + + "AND " + tideBeginDateKey + " BETWEEN :fromDate AND :thruDate)" + " OR (" + tideBeginDateKey + " IS NULL " + - "AND " + createDateKey + " >= :fromDate " + - "AND " + createDateKey + " <= :thruDate)"); + "AND " + createDateKey + " BETWEEN :fromDate AND :thruDate)"); query.addParam("fromDate", period.getFromDate()). addParam("thruDate", period.getThruDate());