Details
-
New Feature
-
Resolution: Fixed
-
Major
-
1.5.0
-
None
-
None
Description
make a lightweight membership view with this query:
GROUPER_MEMBERSHIPS_LW_V
select distinct gm.SUBJECT_ID, gm.SUBJECT_SOURCE, ga.VALUE as group_name,
gfl.NAME as list_name, gfl.TYPE as list_type
from grouper_memberships gms, grouper_members gm,
grouper_attributes ga, grouper_fields gfa, grouper_fields gfl
where gms.OWNER_ID = ga.GROUP_ID and ga.FIELD_ID = gfa.ID
and gfa.NAME = 'name' and gms.FIELD_ID = gfl.ID
and gms.MEMBER_ID = gm.ID