Index: openacs-4/packages/download/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/index-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/download/www/index-oracle.xql	11 May 2001 05:20:45 -0000	1.2
+++ openacs-4/packages/download/www/index-oracle.xql	16 May 2001 02:22:16 -0000	1.3
@@ -49,4 +49,20 @@
       </querytext>
 </fullquery>
  
+<partialquery name="archive_where_clause">      
+      <querytext>
+      
+   dar.revision_id = content_item.get_live_revision(da.archive_id)
+
+      </querytext>
+</partialquery>
+
+<partialquery name="date_clause">      
+      <querytext>
+
+   sysdate
+
+      </querytext>
+</partialquery>
+
 </queryset>