Index: openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/project-manager-procs-postgresql.xql,v diff -u -r1.2 -r1.3 --- openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql 2 Jul 2004 21:17:04 -0000 1.2 +++ openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql 13 Jan 2005 13:54:35 -0000 1.3 @@ -35,5 +35,23 @@ t.name + + + + SELECT DISTINCT + p.first_names || ' ' || p.last_name as name, + p.person_id + FROM + persons p, + acs_rels r, + membership_rels mr + WHERE + r.object_id_one = :user_group_id and + mr.rel_id = r.rel_id and + p.person_id = r.object_id_two and + member_state = 'approved' + ORDER BY name + +