Index: openacs-4/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/www/Attic/index-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/www/index-oracle.xql	30 Jan 2003 22:51:28 -0000	1.2
+++ openacs-4/www/index-oracle.xql	7 Apr 2003 12:16:41 -0000	1.3
@@ -7,14 +7,17 @@
 
   <fullquery name="site_nodes">
     <querytext>
-  select site_node.url(node_id) as url, acs_object.name(object_id) as name
-      from site_nodes
+  select site_node.url(node_id) as url, acs_object.name(object_id) as name,
+         apm_package_types.initial_install_p
+      from site_nodes, apm_packages, apm_package_types
       where parent_id = site_node.node_id('/')
       and object_id is not null
       and acs_permission.permission_p(
           object_id, 
           nvl(:user_id, acs.magic_object_id('the_public')), 
           'read') = 't'
+      and apm_packages.package_id = site_nodes.object_id
+      and apm_package_types.package_key = apm_packages.package_key
     </querytext>
   </fullquery>