<?xml version="1.0"?> <queryset> <fullquery name="group::new.package_select"> <querytext> select t.package_name, lower(t.id_column) as id_column from acs_object_types t where t.object_type = :group_type </querytext> </fullquery> <fullquery name="group::new.package_select"> <querytext> select t.package_name, lower(t.id_column) as id_column from acs_object_types t where t.object_type = :group_type </querytext> </fullquery> <fullquery name="group::get_id_not_cached.get_group_id"> <querytext> select group_id from groups where group_name = :group_name </querytext> </fullquery> <fullquery name="group::get_id_not_cached.get_group_id_with_application"> <querytext> SELECT g.group_id FROM acs_rels rels INNER JOIN composition_rels comp ON rels.rel_id = comp.rel_id INNER JOIN groups g ON rels.object_id_two = g.group_id WHERE rels.object_id_one = :application_group_id AND g.group_name = :group_name </querytext> </fullquery> <fullquery name="group::get_members_not_cached.group_members_party"> <querytext> select distinct member_id from group_member_map where group_id = :group_id </querytext> </fullquery> <fullquery name="group::get_members_not_cached.group_members"> <querytext> select distinct m.member_id from group_member_map m, acs_objects o where m.group_id = :group_id and m.member_id = o.object_id and o.object_type = :type </querytext> </fullquery> <fullquery name="group::join_policy.select_join_policy"> <querytext> select join_policy from groups where group_id = :group_id </querytext> </fullquery> <fullquery name="group::member_p.group_id_from_name"> <querytext> select group_id from groups where group_name = :group_name </querytext> </fullquery> <fullquery name="group::get_rel_segment.select_segment_id"> <querytext> select segment_id from rel_segments where group_id = :group_id and rel_type = :type </querytext> </fullquery> <fullquery name="group::party_member_p.party_is_member"> <querytext> select 1 from group_approved_member_map where member_id = :party_id and group_id = :group_id </querytext> </fullquery> </queryset>