Index: openacs-4/contrib/packages/project-manager/tcl/project-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/project-procs-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/contrib/packages/project-manager/tcl/project-procs-postgresql.xql	12 Mar 2004 13:44:43 -0000	1.4
+++ openacs-4/contrib/packages/project-manager/tcl/project-procs-postgresql.xql	27 Apr 2004 00:49:28 -0000	1.5
@@ -53,6 +53,7 @@
                 :parent_id,
                 :goal,
                 :description,
+                :mime_type,
                 to_timestamp(:planned_start_date,'YYYY MM DD HH24 MI SS'),
                 to_timestamp(:planned_end_date,'YYYY MM DD HH24 MI SS'),
                 null,
@@ -101,12 +102,22 @@
                 else t.actual_hours_worked end as worked,
         t.estimated_hours_work as to_work,
         t.item_id as my_iid,
-        to_char(end_date,'J') as task_deadline_j
+        to_char(end_date,'J') as task_deadline_j,
+        to_char(earliest_start,'J') as old_earliest_start_j,
+        to_char(earliest_finish,'J') as old_earliest_finish_j,
+        to_char(latest_start,'J') as old_latest_start_j,
+        to_char(latest_finish,'J') as old_latest_finish_j,
+        s.status_type
         from
-        pm_tasks_revisionsx t, cr_items i
+        pm_tasks_revisionsx t, 
+        cr_items i,
+        pm_tasks ti,
+        pm_task_status s
         where
         t.item_id in ([join $task_list ", "]) and
-        i.live_revision = t.revision_id
+        i.live_revision = t.revision_id and
+        i.item_id = ti.task_id and
+        ti.status = s.status_id
     </querytext>
   </fullquery>