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.27 -r1.28
--- openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	30 Jun 2004 16:43:29 -0000	1.27
+++ openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	24 Jul 2004 08:33:55 -0000	1.28
@@ -56,7 +56,9 @@
         t.estimated_hours_work,
         t.estimated_hours_work_min,
         t.estimated_hours_work_max,
-        t.actual_hours_worked
+        t.actual_hours_worked,
+        s.status_type,
+        s.description as status_description
 	FROM
 	(select * from pm_tasks_revisionsx 
          LEFT JOIN
@@ -70,14 +72,13 @@
            pm_task_dependency d 
            ON 
            i.item_id = d.task_id,
-        pm_tasks ti,
+        pm_tasks_active ti,
         pm_task_status s
 	WHERE
         t.parent_id = :project_item_id and
         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
+        ti.status     = s.status_id
         [template::list::orderby_clause -name tasks -orderby]
     </querytext>
   </fullquery>