Index: openacs-4/packages/acs-subsite/www/admin/rel-segments/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/rel-segments/index-oracle.xql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/acs-subsite/www/admin/rel-segments/index-oracle.xql 15 May 2001 16:59:00 -0000 1.1 +++ openacs-4/packages/acs-subsite/www/admin/rel-segments/index-oracle.xql 20 Jun 2018 09:21:15 -0000 1.2 @@ -6,7 +6,8 @@ - select s.segment_id, s.segment_name, s.group_id, acs_object.name(s.group_id) as group_name, + select s.segment_id, s.segment_name, s.group_id, + (select group_name from groups where group_id = s.group_id) as group_name, s.rel_type, t.pretty_name as rel_type_pretty_name from acs_object_types t, rel_segments s,