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.2.2 -r1.23.2.3
--- openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	2 Jul 2004 23:13:49 -0000	1.23.2.2
+++ openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	15 Jul 2004 22:13:10 -0000	1.23.2.3
@@ -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
@@ -76,8 +78,7 @@
         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>