Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-231

make a lightweight membership view

    XMLWordPrintable

Details

    • New Feature
    • Resolution: Fixed
    • Major
    • 1.5.0
    • 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

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: