Index: openacs-4/packages/file-storage/www/view/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/view/index-oracle.xql,v
diff -u -r1.1 -r1.1.8.1
--- openacs-4/packages/file-storage/www/view/index-oracle.xql	7 Jul 2003 12:37:39 -0000	1.1
+++ openacs-4/packages/file-storage/www/view/index-oracle.xql	26 Sep 2005 09:00:19 -0000	1.1.8.1
@@ -11,5 +11,24 @@
       </querytext>
 </fullquery>
 
+<fullquery name="upgraded_item_id">      
+      <querytext>
+
+	    select i.item_id
+	    from cr_revisions r, cr_items i 
+	    where r.item_id = i.item_id 
+	    and r.title = :item_url_title 
+	    and i.parent_id in (select item_id 
+			       from cr_items 
+			       where name = :item_url_folder
+			       and parent_id in (select item_id
+						from cr_items
+						where name = :item_url_parent_folder))
+	    and rownum = 1
+	    order by revision_id desc
+
+      </querytext>
+</fullquery>
+
  
 </queryset>