Index: openacs-4/packages/bookmarks/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/www/index-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/bookmarks/www/index-oracle.xql	7 Jun 2001 20:26:06 -0000	1.3
+++ openacs-4/packages/bookmarks/www/index-oracle.xql	18 Oct 2001 19:38:41 -0000	1.4
@@ -64,6 +64,41 @@
       </querytext>
 </fullquery>
 
+<fullquery name="my_bookmarks_select">      
+      <querytext>
+      select b.bookmark_id,
+b.url_id,
+b.local_title as bookmark_title,
+u.complete_url,
+u.last_live_date, 
+u.last_checked_date, 
+b.folder_p, 
+bm_in_closed_p.closed_p, 
+nvl(admin_view.object_id, 0) as admin_p,
+nvl(delete_view.object_id,0) as delete_p,
+b.lev as indentation
+$private_select
+
+from bm_urls u,
+(select $index_order bookmark_id, url_id, local_title, folder_p, level lev, parent_id, rownum ord_num 
+from bm_bookmarks start with bookmark_id = :root_folder_id connect by prior bookmark_id = parent_id) b,
+bm_in_closed_p,
+(select object_id from acs_object_party_privilege_map
+ where party_id in (:browsing_user_id, -1) and privilege = 'admin') admin_view,
+(select object_id from acs_object_party_privilege_map
+ where party_id in (:browsing_user_id, -1) and privilege = 'delete') delete_view
+where b.url_id = u.url_id (+)
+and bm_in_closed_p.bookmark_id = b.bookmark_id
+and bm_in_closed_p.in_closed_p = 'f'
+and bm_in_closed_p.in_closed_p_id = :in_closed_p_id
+and exists (select 1 from bm_bookmarks where exists (select 1 from acs_object_party_privilege_map where object_id = bookmark_id and party_id in (:browsing_user_id, -1) and privilege = 'read') start with bookmark_id = b.bookmark_id connect by prior bookmark_id = parent_id)
+and b.bookmark_id <> :root_folder_id
+and b.bookmark_id = admin_view.object_id(+)
+and b.bookmark_id = delete_view.object_id(+)
+order by ord_num
+      </querytext>
+</fullquery>
+
  
 </queryset>