oracle8.1.6
select distinct h.community_key,
h.community_id,
h.pretty_name,
h.parent_community_id
from dotlrn_communities h, dotlrn_clubs c
where (h.parent_community_id is not null
or c.club_id = h.community_id)
and upper(substr(h.pretty_name, 1, 1)) = :section
order by h.pretty_name
select distinct h.community_key,
h.community_id,
h.pretty_name,
h.parent_community_id
from dotlrn_communities h, dotlrn_clubs c
where (h.parent_community_id is not null
or c.club_id = h.community_id)
and upper(substr(h.pretty_name, 1, 1)) not in ('[join $dimension_list "\', \'"]')
order by h.pretty_name
select dotlrn_communities_full.community_key,
dotlrn_communities_full.community_id,
dotlrn_communities_full.pretty_name
from dotlrn_classes, dotlrn_communities_full
where dotlrn_communities_full.community_type = dotlrn_classes.class_key
and upper(substr(dotlrn_communities_full.pretty_name, 1, 1)) = :section
order by dotlrn_communities_full.pretty_name
select dotlrn_communities_full.community_key,
dotlrn_communities_full.community_id,
dotlrn_communities_full.pretty_name
from dotlrn_classes, dotlrn_communities_full
where dotlrn_communities_full.community_type = dotlrn_classes.class_key
and upper(substr(dotlrn_communities_full.pretty_name, 1, 1)) not in ('[join $dimension_list "\', \'"]')
order by dotlrn_communities_full.pretty_name
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 upper(substr(dotlrn_users.last_name, 1, 1)) = :section
order by dotlrn_users.last_name
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 upper(substr(dotlrn_users.last_name, 1, 1)) not in ('[join $dimension_list "\', \'"]')
order by dotlrn_users.last_name