Index: openacs-4/packages/bug-tracker/www/admin/component-ae-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/admin/Attic/component-ae-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/bug-tracker/www/admin/component-ae-oracle.xql	28 Aug 2003 09:45:30 -0000	1.2
@@ -0,0 +1,18 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="user_search">
+  <querytext>
+      select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
+      from   cc_users u
+      where  upper(nvl(u.first_names || ' ', '')  ||
+             nvl(u.last_name || ' ', '') ||
+             u.email || ' ' ||
+             nvl(u.screen_name, '')) like upper('%'||:value||'%')
+      order  by name
+  </querytext>
+</fullquery>
+
+</queryset>