Index: openacs-4/contrib/packages/project-manager/www/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/one-postgresql.xql,v
diff -u -r1.23 -r1.23.2.1
--- openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	12 Mar 2004 13:44:45 -0000	1.23
+++ openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	20 May 2004 17:30:05 -0000	1.23.2.1
@@ -10,6 +10,7 @@
 	p.project_code,
 	p.goal,
 	p.description,
+        p.mime_type, 
 	to_char(p.planned_start_date,'YYYY-MM-DD HH24:MI') as planned_start_date,
 	to_char(p.planned_end_date,'YYYY-MM-DD HH24:MI') as planned_end_date,
         p.logger_project,
@@ -84,10 +85,26 @@
         t.estimated_hours_work_max,
         t.actual_hours_worked
 	FROM
-	(select * from pm_tasks_revisionsx LEFT JOIN pm_task_assignment ON item_id = task_id) t LEFT JOIN persons u ON t.party_id = u.person_id, cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id
+	(select * from pm_tasks_revisionsx 
+         LEFT JOIN
+         pm_task_assignment ON item_id = task_id) t 
+           LEFT JOIN 
+           persons u 
+           ON 
+           t.party_id = u.person_id, 
+        cr_items i 
+           LEFT JOIN 
+           pm_task_dependency d 
+           ON 
+           i.item_id = d.task_id,
+        pm_tasks ti,
+        pm_task_status s
 	WHERE
         t.parent_id = :project_item_id and
-        t.revision_id = i.live_revision 
+        t.revision_id = i.live_revision and
+        t.item_id     = ti.task_id and
+        ti.status     = s.status_id and
+        s.status_type = :status_type
         [template::list::orderby_clause -name tasks -orderby]
     </querytext>
   </fullquery>