...
This view has the loader results to load the groups with attributes. Note, since all the groups used are loaded basis groups (not in this example, but yes in practice) with immediate memberships, we can join to the grouper_memberships table. This is done for performance reasons. If there were effective members, then the grouper_memberships_lw_v would need to be used, and the grouper_groups/grouper_fields table wouldnt be needed since that is in the view.Note also the field_id of the "members" field from grouper_fields is hard-coded here. If you use grouper_memberships_lw_v you dont need to do that.
| Code Block |
|---|
create view employee_intersect_mships_v as
select eio.group_name as group_name,
gm.subject_id as subject_id,
gm.subject_source as subject_source_id
from employee_intersect_owners eio,
grouper_members gm
where
(eio.has_job_class = 'T' or eio.has_job_code = 'T' or eio.has_org_unit_code = 'T')
and (eio.has_job_class = 'F'
or exists (select 1 from grouper_memberships gms, employee_intersect_unions eiu, grouper_groups gg, grouper_fields gf
where eiu.group_id_owner = eio.group_id and gf.name = 'members' and gf.id = gms.field_id
and gm.id = gms.member_id and gms.enabled = 'T'
and eiu.union_attribute = 'jobClass' and gg.name = eiu.group_name_union and gms.owner_id = gg.id ))
and (eio.has_job_code = 'F'
or exists (select 1 from grouper_memberships gms, employee_intersect_unions eiu, grouper_groups gg, grouper_fields gf
where eiu.group_id_owner = eio.group_id and gf.name = 'members' and gf.id = gms.field_id
and gm.id = gms.member_id and gms.enabled = 'T'
and eiu.union_attribute = 'jobCode' and gg.name = eiu.group_name_union and gms.owner_id = gg.id ))
and (eio.has_org_unit_code = 'F'
or exists (select 1 from grouper_memberships gms, employee_intersect_unions eiu, grouper_groups gg, grouper_fields gf
where eiu.group_id_owner = eio.group_id and gf.name = 'members' and gf.id = gms.field_id
and gm.id = gms.member_id and gms.enabled = 'T'
and eiu.union_attribute = 'orgUnitCode' and gg.name = eiu.group_name_union and gms.owner_id = gg.id )) |
...