Index: openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-one-postgresql.xql,v
diff -u -r1.17 -r1.18
--- openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql	26 Jan 2004 15:39:40 -0000	1.17
+++ openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql	26 Feb 2004 15:15:41 -0000	1.18
@@ -53,13 +53,17 @@
         t.estimated_hours_work_min,
         t.estimated_hours_work_max,
         t.percent_complete,
-        i.live_revision
+        i.live_revision,
+	p.first_names || ' ' || p.last_name as creation_user
 	FROM
-	pm_tasks_revisionsx t, cr_items i
+	pm_tasks_revisionsx t, 
+        cr_items i,
+        persons p
 	WHERE
         t.item_id = :task_id and
         t.revision_id = :task_revision_id and
-        t.item_id = i.item_id
+        t.item_id = i.item_id and
+        t.creation_user = p.person_id
     </querytext>
   </fullquery>
 
@@ -70,17 +74,18 @@
         t.revision_id,
         i.live_revision,
         t.title as task_title,
-        t.description,
+        t.description || ' -- ' || p.first_names || ' ' || p.last_name as description,
 	to_char(t.end_date,'MM/DD/YYYY') as end_date,
         t.percent_complete,
         t.estimated_hours_work_min,
         t.estimated_hours_work_max,
         t.actual_hours_worked        
 	FROM
-	pm_tasks_revisionsx t, cr_items i
+	pm_tasks_revisionsx t, cr_items i, persons p
 	WHERE
         t.item_id = :task_id and
-        t.item_id = i.item_id
+        t.item_id = i.item_id and
+        t.creation_user = p.person_id
         [template::list::orderby_clause -name revisions -orderby]
     </querytext>
   </fullquery>