Index: openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/tasks-postgresql.xql,v
diff -u -r1.8 -r1.9
--- openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	24 Jul 2004 08:33:56 -0000	1.8
+++ openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	13 Jan 2005 13:54:36 -0000	1.9
@@ -5,8 +5,7 @@
 <fullquery name="tasks">
     <querytext>
         SELECT
-        ts.task_id,
-        ts.task_id as item_id,
+        ts.task_id as task_item_id,
         ts.task_number,
         t.task_revision_id,
         t.title,
@@ -30,15 +29,17 @@
         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,
-        (select one_line from pm_roles r where ta.role_id = r.role_id) as role
+        r.one_line as role
         FROM
         pm_tasks_active ts, 
         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,
+            ON ta.party_id = p.person_id
+            LEFT JOIN pm_roles r
+            ON ta.role_id = r.role_id,
         cr_items proj,
         pm_projectsx proj_rev
         WHERE