Index: openacs-4/packages/lorsm/www/delivery/view/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/delivery/view/index-postgresql.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/lorsm/www/delivery/view/index-postgresql.xql	4 Sep 2004 14:51:26 -0000	1.1
+++ openacs-4/packages/lorsm/www/delivery/view/index-postgresql.xql	5 May 2006 17:00:20 -0000	1.1.4.1
@@ -11,5 +11,17 @@
       </querytext>
 </fullquery>
 
+<fullquery name="get_item_id">
+      <querytext>
+    select content_item__get_id(:url, :content_root, 'f') as item_id
+      </querytext>
+</fullquery>
  
+<fullquery name="check_file_to_imsitem">
+      <querytext>
+ select i.ims_item_id as imsitem_id from ims_cp_items_to_resources i, ims_cp_files f where f.file_id=:file_id and i.res_id=f.res_id;
+      </querytext>
+</fullquery>
+
+
 </queryset>