Index: openacs-4/packages/dotlrn/www/admin/users-chunk-large-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/users-chunk-large-oracle.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/dotlrn/www/admin/users-chunk-large-oracle.xql	18 Feb 2002 21:02:51 -0000	1.5
+++ openacs-4/packages/dotlrn/www/admin/users-chunk-large-oracle.xql	6 Mar 2002 00:08:02 -0000	1.6
@@ -49,4 +49,27 @@
       </querytext>
     </fullquery>
 
+    <fullquery name="select_deactivated_users">
+      <querytext>
+        select cc_users.user_id,
+               cc_users.first_names,
+               cc_users.last_name,
+               cc_users.email,
+               'limited' as access_level,
+               'f' as read_private_data_p,
+               acs_permission.permission_p(:root_object_id, cc_users.user_id, 'admin') as site_wide_admin_p
+        from cc_users
+        where not exists (select 1
+                          from dotlrn_users
+                          where dotlrn_users.user_id = cc_users.user_id)
+        and cc_users.member_state = 'banned'
+        and (
+            lower(cc_users.last_name) like lower('%' || :search_text || '%')
+         or lower(cc_users.first_names) like lower('%' || :search_text || '%')
+         or lower(cc_users.email) like lower('%' || :search_text || '%')
+        )
+        order by cc_users.last_name
+      </querytext>
+    </fullquery>
+
 </queryset>