Index: openacs-4/contrib/packages/project-manager/tcl/calendar-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/calendar-procs-postgresql.xql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- openacs-4/contrib/packages/project-manager/tcl/calendar-procs-postgresql.xql	6 Aug 2004 18:28:18 -0000	1.1.2.2
+++ openacs-4/contrib/packages/project-manager/tcl/calendar-procs-postgresql.xql	13 Aug 2004 18:57:34 -0000	1.1.2.3
@@ -34,16 +34,19 @@
         to_char(t.latest_start,'YYYY-MM-DD HH24:MI') as latest_start,
         to_char(t.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish,
         p.first_names || ' ' || p.last_name as full_name,
-        p.person_id
+        p.person_id,
+        s.status_type as status
         FROM
         pm_tasks_active ts, 
+        pm_task_status s,
         cr_items i,
         pm_tasks_revisionsx t 
           LEFT JOIN pm_task_assignment ta
           ON t.item_id = ta.task_id
             LEFT JOIN persons p 
             ON ta.party_id = p.person_id
         WHERE
+        ts.status   = s.status_id and
         ts.task_id  = t.item_id and
         i.item_id   = t.item_id and
         t.task_revision_id = i.live_revision and