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.13 -r1.14
--- openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql	5 Sep 2003 00:29:05 -0000	1.13
+++ openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql	12 Sep 2003 01:20:57 -0000	1.14
@@ -120,4 +120,21 @@
         [template::list::orderby_clause -name dependency2 -orderby]
     </querytext>
   </fullquery>
+
+  <fullquery name="task_people_query">
+    <querytext>
+        select
+        r.one_line,
+        u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as user_info
+        from 
+        pm_task_assignment a,
+        cc_users u,
+        pm_roles r
+        where 
+        a.task_id  = :task_id and
+        u.party_id = a.party_id and
+        a.role_id  = r.role_id
+    </querytext>
+  </fullquery>
+
 </queryset>