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.3 -r1.4
--- openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	26 Jan 2004 15:39:40 -0000	1.3
+++ openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	26 Feb 2004 15:28:34 -0000	1.4
@@ -10,7 +10,11 @@
         t.task_revision_id,
         t.title,
         t.description,
-        to_char(t.end_date,'YYYY-MM-DD HH24:MI') as end_date,
+        to_char(t.earliest_start,'J') as earliest_start_j,
+        to_char(current_timestamp,'J') as today_j,
+        to_char(t.latest_start,'J') as latest_start_j,
+        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,
         t.percent_complete,
         t.estimated_hours_work,
         t.estimated_hours_work_min,
@@ -21,18 +25,16 @@
         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,
-        r.one_line as role
+        (select one_line from pm_roles r where ta.role_id = r.role_id) as role
         FROM
         pm_tasks ts, 
         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,
-        pm_roles r
+            ON ta.party_id = p.person_id
         WHERE
-        ts.task_id  = t.item_id and
-        ta.role_id = r.role_id 
+        ts.task_id  = t.item_id 
         [template::list::filter_where_clauses -and -name tasks]
         [template::list::orderby_clause -orderby -name tasks]
     </querytext>