Index: openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list-oracle.xql,v
diff -u -r1.1.30.1 -r1.1.30.2
--- openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list-oracle.xql	1 Jul 2016 13:47:06 -0000	1.1.30.1
+++ openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list-oracle.xql	3 Jul 2016 14:10:41 -0000	1.1.30.2
@@ -1,7 +1,5 @@
 <?xml version="1.0"?>
-
 <queryset>
-   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
 <fullquery name="rel_type_info">      
       <querytext>
@@ -38,5 +36,24 @@
       </querytext>
 </fullquery>
 
+<fullquery name="relations_query">      
+      <querytext>
+
+select r.rel_id, 
+       party_names.party_name as element_name
+from (select DISTINCT rels.rel_id, object_id_two
+      from $extra_tables acs_rels rels, acs_object_party_privilege_map perm
+      where perm.object_id = rels.rel_id
+        and perm.party_id = :user_id
+        and perm.privilege = 'read'
+        and rels.rel_type = :rel_type
+        and rels.object_id_one = :group_id $extra_where_clauses) r, 
+     party_names 
+where r.object_id_two = party_names.party_id
+order by element_name
+
+      </querytext>
+</fullquery>
+
  
 </queryset>