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.10 -r1.11
--- openacs-4/packages/dotlrn/www/admin/users-chunk-large-oracle.xql	28 Apr 2002 04:08:42 -0000	1.10
+++ openacs-4/packages/dotlrn/www/admin/users-chunk-large-oracle.xql	1 May 2002 01:19:47 -0000	1.11
@@ -1,89 +1,89 @@
 <?xml version="1.0"?>
 
 <queryset>
-  <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
     <fullquery name="select_dotlrn_users">
-      <querytext>
-        select dotlrn_users.user_id,
-               dotlrn_users.first_names,
-               dotlrn_users.last_name,
-               dotlrn_users.email,
-               dotlrn_users.access_level,
-               acs_permission.permission_p(:dotlrn_package_id, dotlrn_users.user_id, 'read_private_data') as read_private_data_p,
-               acs_permission.permission_p(:root_object_id, dotlrn_users.user_id, 'admin') as site_wide_admin_p
-        from dotlrn_users
-        where dotlrn_users.type = :type
-        and (
-            lower(dotlrn_users.last_name) like lower('%' || :search_text || '%')
-         or lower(dotlrn_users.first_names) like lower('%' || :search_text || '%')
-         or lower(dotlrn_users.email) like lower('%' || :search_text || '%')
-        )
-        order by dotlrn_users.last_name
-      </querytext>
+        <querytext>
+            select dotlrn_users.user_id,
+                   dotlrn_users.first_names,
+                   dotlrn_users.last_name,
+                   dotlrn_users.email,
+                   dotlrn_users.access_level,
+                   acs_permission.permission_p(:dotlrn_package_id, dotlrn_users.user_id, 'read_private_data') as read_private_data_p,
+                   acs_permission.permission_p(:root_object_id, dotlrn_users.user_id, 'admin') as site_wide_admin_p
+            from dotlrn_users
+            where dotlrn_users.type = :type
+            and (
+                lower(dotlrn_users.last_name) like lower('%' || :search_text || '%')
+             or lower(dotlrn_users.first_names) like lower('%' || :search_text || '%')
+             or lower(dotlrn_users.email) like lower('%' || :search_text || '%')
+            )
+            order by dotlrn_users.last_name
+        </querytext>
     </fullquery>
 
     <fullquery name="select_non_dotlrn_users">
-      <querytext>
-        select users.user_id,
-               persons.first_names,
-               persons.last_name,
-               parties.email,
-               'limited' as access_level,
-               'f' as read_private_data_p,
-               acs_permission.permission_p(:root_object_id, users.user_id, 'admin') as site_wide_admin_p
-        from parties,
-             users,
-             persons,
-             acs_rels,
-             membership_rels
-        where parties.party_id = users.user_id
-        and users.user_id = persons.person_id
-        and persons.person_id = acs_rels.object_id_two
-        and acs_rels.object_id_one = acs.magic_object_id('registered_users')
-        and acs_rels.rel_id = membership_rels.rel_id
-        and membership_rels.member_state = 'approved'
-        and not exists (select 1
-                        from acs_rels a,
-                             dotlrn_user_types
-                        where a.object_id_one = dotlrn_user_types.group_id
-                        and a.object_id_two = acs_rels.object_id_two)
-        and (
-            lower(persons.last_name) like lower('%' || :search_text || '%')
-         or lower(persons.first_names) like lower('%' || :search_text || '%')
-         or lower(parties.email) like lower('%' || :search_text || '%')
-        )
-        order by persons.last_name
-      </querytext>
+        <querytext>
+            select users.user_id,
+                   persons.first_names,
+                   persons.last_name,
+                   parties.email,
+                   'limited' as access_level,
+                   'f' as read_private_data_p,
+                   acs_permission.permission_p(:root_object_id, users.user_id, 'admin') as site_wide_admin_p
+            from parties,
+                 users,
+                 persons,
+                 acs_rels,
+                 membership_rels
+            where parties.party_id = users.user_id
+            and users.user_id = persons.person_id
+            and persons.person_id = acs_rels.object_id_two
+            and acs_rels.object_id_one = acs.magic_object_id('registered_users')
+            and acs_rels.rel_id = membership_rels.rel_id
+            and membership_rels.member_state = 'approved'
+            and not exists (select 1
+                            from acs_rels a,
+                                 dotlrn_user_types
+                            where a.object_id_one = dotlrn_user_types.group_id
+                            and a.object_id_two = acs_rels.object_id_two)
+            and (
+                lower(persons.last_name) like lower('%' || :search_text || '%')
+             or lower(persons.first_names) like lower('%' || :search_text || '%')
+             or lower(parties.email) like lower('%' || :search_text || '%')
+            )
+            order by persons.last_name
+        </querytext>
     </fullquery>
 
     <fullquery name="select_deactivated_users">
-      <querytext>
-        select users.user_id,
-               persons.first_names,
-               persons.last_name,
-               parties.email,
-               'limited' as access_level,
-               'f' as read_private_data_p,
-               acs_permission.permission_p(:root_object_id, users.user_id, 'admin') as site_wide_admin_p
-        from parties,
-             users,
-             persons,
-             acs_rels,
-             membership_rels
-        where parties.party_id = users.user_id
-        and users.user_id = persons.person_id
-        and persons.person_id = acs_rels.object_id_two
-        and acs_rels.object_id_one = acs.magic_object_id('registered_users')
-        and acs_rels.rel_id = membership_rels.rel_id
-        and membership_rels.member_state = 'banned'
-        and (
-            lower(persons.last_name) like lower('%' || :search_text || '%')
-         or lower(persons.first_names) like lower('%' || :search_text || '%')
-         or lower(parties.email) like lower('%' || :search_text || '%')
-        )
-        order by persons.last_name
-      </querytext>
+        <querytext>
+            select users.user_id,
+                   persons.first_names,
+                   persons.last_name,
+                   parties.email,
+                   'limited' as access_level,
+                   'f' as read_private_data_p,
+                   acs_permission.permission_p(:root_object_id, users.user_id, 'admin') as site_wide_admin_p
+            from parties,
+                 users,
+                 persons,
+                 acs_rels,
+                 membership_rels
+            where parties.party_id = users.user_id
+            and users.user_id = persons.person_id
+            and persons.person_id = acs_rels.object_id_two
+            and acs_rels.object_id_one = acs.magic_object_id('registered_users')
+            and acs_rels.rel_id = membership_rels.rel_id
+            and membership_rels.member_state = 'banned'
+            and (
+                lower(persons.last_name) like lower('%' || :search_text || '%')
+             or lower(persons.first_names) like lower('%' || :search_text || '%')
+             or lower(parties.email) like lower('%' || :search_text || '%')
+            )
+            order by persons.last_name
+        </querytext>
     </fullquery>
 
 </queryset>