oracle8.1.6
select dotlrn_users.user_id,
dotlrn_users.first_names,
dotlrn_users.last_name,
dotlrn_users.email,
dotlrn_privacy.guest_p(dotlrn_users.user_id) as guest_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
select users.user_id,
persons.first_names,
persons.last_name,
parties.email,
'f' as guest_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 member_state not in ('banned','deleted','rejected')
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 users.email_verified_p = 't'
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
select users.user_id,
persons.first_names,
persons.last_name,
parties.email,
'f' as guest_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