Index: openacs-4/packages/logger/tcl/project-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/logger/tcl/project-procs.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/logger/tcl/project-procs.xql	11 Dec 2003 21:40:07 -0000	1.7
+++ openacs-4/packages/logger/tcl/project-procs.xql	27 Feb 2004 17:43:51 -0000	1.8
@@ -91,5 +91,20 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="logger::project::users_get_options.select_project_leads">
+    <querytext>
+        select uouter.first_names || ' ' || uouter.last_name, uouter.user_id
+        from   cc_users uouter
+        where  uouter.user_id in (select distinct u.user_id
+                                  from   cc_users u
+                                  where  u.user_id in (select p.project_lead
+                                                       from   logger_projects p,
+                                                              logger_project_pkg_map ppm
+                                                       where  ppm.project_id = p.project_id
+                                                       and    ppm.package_id = :package_id)
+                                  or     u.user_id = :user_id)
+        order  by lower(uouter.first_names), lower(uouter.last_name)
+    </querytext>
+  </fullquery>
 
 </queryset>