Index: openacs-4/packages/acs-subsite/www/admin/group-types/groups-list-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/group-types/groups-list-postgresql.xql,v diff -u -N -r1.1.30.2 -r1.1.30.3 --- openacs-4/packages/acs-subsite/www/admin/group-types/groups-list-postgresql.xql 3 Jul 2016 11:38:02 -0000 1.1.30.2 +++ openacs-4/packages/acs-subsite/www/admin/group-types/groups-list-postgresql.xql 14 Jul 2016 17:08:04 -0000 1.1.30.3 @@ -2,18 +2,18 @@ - - - select DISTINCT g.group_id, g.group_name - from (select group_id, group_name + + select g.group_id, g.group_name from ( + select DISTINCT g.group_id, g.group_name + from (select group_id, group_name from groups g, acs_objects o where g.group_id = o.object_id and o.object_type = :group_type) g, application_group_element_map m - where m.package_id = :package_id - and m.element_id = g.group_id - and acs_permission__permission_p(g.group_id, :user_id, 'read') - + where m.package_id = :package_id + and m.element_id = g.group_id + and acs_permission.permission_p(g.group_id, :user_id, 'read') + ) g order by lower(g.group_name)