Index: openacs-4/contrib/packages/project-manager/www/task-select-project-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-select-project-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/project-manager/www/task-select-project-postgresql.xql	6 Oct 2003 22:57:28 -0000	1.1
+++ openacs-4/contrib/packages/project-manager/www/task-select-project-postgresql.xql	12 Mar 2004 13:44:45 -0000	1.2
@@ -6,9 +6,11 @@
         SELECT
         p.item_id as project_item_id,
         p.title as project_name
-        FROM pm_projectsx p, cr_items i
+        FROM pm_projectsx p, cr_items i, pm_project_status s
         WHERE p.project_id = i.live_revision and
-        p.parent_id = :root_folder
+        p.parent_id = :root_folder and
+        p.status_id = s.status_id and
+        s.status_type = 'o'
         ORDER BY p.title
     </querytext>
   </fullquery>