Index: openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql,v diff -u -N -r1.6 -r1.7 --- openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql 30 Jul 2005 00:26:33 -0000 1.6 +++ openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql 23 Aug 2005 16:22:39 -0000 1.7 @@ -214,6 +214,7 @@ WHERE p.project_id = i.live_revision and s.status_id = p.status_id and + $extra_query s.status_type = 'o' ORDER BY lower(p.title), lower(o.name)