Author: tmortagne
Date: 2008-01-16 21:38:38 +0100 (Wed, 16 Jan 2008)
New Revision: 6873

Modified:
   
xwiki-platform/xwiki-plugins/trunk/watchlist/src/main/java/com/xpn/xwiki/plugin/watchlist/WatchListJob.java
Log:
XPWATCHLIST-6: Invalid query in watch list plugin and Oracle.
Applied Jean-Vincent Drean's patch without modification.

Modified: 
xwiki-platform/xwiki-plugins/trunk/watchlist/src/main/java/com/xpn/xwiki/plugin/watchlist/WatchListJob.java
===================================================================
--- 
xwiki-platform/xwiki-plugins/trunk/watchlist/src/main/java/com/xpn/xwiki/plugin/watchlist/WatchListJob.java
 2008-01-16 20:25:32 UTC (rev 6872)
+++ 
xwiki-platform/xwiki-plugins/trunk/watchlist/src/main/java/com/xpn/xwiki/plugin/watchlist/WatchListJob.java
 2008-01-16 20:38:38 UTC (rev 6873)
@@ -259,9 +259,10 @@
                 dt = dt.minus(Months.ONE);
                 break;
         }
-        String updatedDocumentRequest = "where doc.date > '" +
-            xwiki.formatDate(dt.toDate(), "yyyy-MM-dd HH:mm:ss.SSS") + "' 
order by doc.date desc";
-        return xwiki.searchDocuments(updatedDocumentRequest);
+        List values = new ArrayList();
+        values.add(dt.toDate());
+        String updatedDocumentRequest = "where doc.date > ? order by doc.date 
desc";
+        return xwiki.searchDocuments(updatedDocumentRequest, 0, 0, values);
     }
 
     /**

_______________________________________________
notifications mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/notifications

Reply via email to