Index: openacs-4/contrib/packages/project-manager/www/process-one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/process-one-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/contrib/packages/project-manager/www/process-one-postgresql.xql	25 Jun 2004 00:04:42 -0000	1.4
+++ openacs-4/contrib/packages/project-manager/www/process-one-postgresql.xql	13 Jan 2005 13:54:36 -0000	1.5
@@ -11,14 +11,28 @@
         t.estimated_hours_work_min,
         t.estimated_hours_work_max,
         d.dependency_type,
-        t.ordering
+        t.ordering,
+        p.first_names,
+        p.last_name,
+        p.person_id
 	FROM
         pm_process_task t 
+          LEFT JOIN
+          pm_process_task_assignment a
+          ON 
+          t.process_task_id = a.process_task_id
+            LEFT JOIN
+            pm_roles r
+            ON r.role_id = a.role_id
           LEFT JOIN 
+          persons p 
+          ON p.person_id = a.party_id
+          LEFT JOIN 
           pm_process_task_dependency d 
           ON t.process_task_id = d.process_task_id 
 	WHERE
-	t.process_id = :process_id
+	t.process_id = :process_id and
+        (r.is_lead_p = 't' or r.is_lead_p is null)
         [template::list::orderby_clause -orderby -name tasks]
     </querytext>
   </fullquery>