Index: openacs-4/contrib/packages/project-manager/www/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/one-postgresql.xql,v
diff -u -r1.23.2.4 -r1.23.2.5
--- openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	16 Jul 2004 20:59:41 -0000	1.23.2.4
+++ openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	8 Oct 2004 21:25:05 -0000	1.23.2.5
@@ -58,15 +58,19 @@
         t.estimated_hours_work_max,
         t.actual_hours_worked,
         s.status_type,
-        s.description as status_description
+        s.description as status_description,
+        r.is_lead_p
 	FROM
 	(select * from pm_tasks_revisionsx 
          LEFT JOIN
          pm_task_assignment ON item_id = task_id) t 
            LEFT JOIN 
            persons u 
            ON 
-           t.party_id = u.person_id, 
+           t.party_id = u.person_id 
+           LEFT JOIN
+           pm_roles r
+           ON t.role_id = r.role_id,  
         cr_items i 
            LEFT JOIN 
            pm_task_dependency d 
@@ -75,10 +79,10 @@
         pm_tasks_active ti,
         pm_task_status s
 	WHERE
-        t.parent_id = :project_item_id and
-        t.revision_id = i.live_revision and
-        t.item_id     = ti.task_id and
-        ti.status     = s.status_id
+        t.parent_id     = :project_item_id and
+        t.revision_id   = i.live_revision and
+        t.item_id       = ti.task_id and
+        ti.status       = s.status_id
         [template::list::orderby_clause -name tasks -orderby]
     </querytext>
   </fullquery>