Index: openacs-4/contrib/packages/project-manager/www/task-assign-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-assign-add-edit-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/contrib/packages/project-manager/www/task-assign-add-edit-postgresql.xql	10 Oct 2003 22:51:04 -0000	1.4
+++ openacs-4/contrib/packages/project-manager/www/task-assign-add-edit-postgresql.xql	26 Jan 2004 15:39:40 -0000	1.5
@@ -1,22 +1,34 @@
 <?xml version="1.0"?>
 <queryset>
-  <fullquery name="get_task_item_ids">
+  <fullquery name="get_task_info">
     <querytext>
       select
+        title as one_line,
+        description,
         item_id
 	FROM
 	pm_tasks_revisionsx t
         WHERE
         revision_id in ([join $revisions ","])
+        ORDER BY
+        item_id
     </querytext>
   </fullquery>
 
-  <fullquery name="get_task_info">
+  <fullquery name="get_more_task_info">
     <querytext>
       select
         title as one_line,
         description,
-        item_id
+        item_id,
+        to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as end_date_ansi,
+        estimated_hours_work,
+        estimated_hours_work_min,
+        estimated_hours_work_max,
+        to_char(earliest_start, 'YYYY-MM-DD HH24:MI:SS') as earliest_start_ansi,
+        to_char(earliest_finish, 'YYYY-MM-DD HH24:MI:SS') as earliest_finish_ansi,
+        to_char(latest_start, 'YYYY-MM-DD HH24:MI:SS') as latest_start_ansi,
+        to_char(latest_finish, 'YYYY-MM-DD HH24:MI:SS') as latest_finish_ansi
 	FROM
 	pm_tasks_revisionsx t
         WHERE
@@ -104,4 +116,18 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="get_project_name">
+    <querytext>
+      select
+        title
+	FROM
+        pm_projects p, cr_revisions r, cr_items i
+        WHERE
+        r.item_id = :project_item_id and
+        i.item_id = r.item_id and
+        p.project_id = i.live_revision and
+        p.project_id = r.revision_id
+    </querytext>
+  </fullquery>
+
 </queryset>