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

add a lookup table for view params (i.e. "etc" is configurable and doesnt work with "inst:etc"

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Minor
    • None
    • None
    • None
    • None

    Description

      CREATE OR REPLACE VIEW penngrouper.grouper_recent_mships_conf_v
      AS SELECT DISTINCT gg.name AS group_name_from,
      gaaagv_groupuuidfrom.value_string AS group_uuid_from,
      gaaagv_recentmembershipsmicros.value_integer AS recent_micros,
      gaaagv_groupuuidfrom.group_id AS group_uuid_to,
      gaaagv_groupuuidfrom.group_name AS group_name_to,
      gaaagv_includeeligible.value_string AS include_eligible
      FROM grouper_aval_asn_asn_group_v gaaagv_recentmembershipsmicros,
      grouper_aval_asn_asn_group_v gaaagv_groupuuidfrom,
      grouper_aval_asn_asn_group_v gaaagv_includeeligible,
      grouper_groups gg
      WHERE gaaagv_recentmembershipsmicros.attribute_assign_id1::text = gaaagv_groupuuidfrom.attribute_assign_id1::text AND gaaagv_recentmembershipsmicros.attribute_assign_id1::text = gaaagv_includeeligible.attribute_assign_id1::text AND gaaagv_recentmembershipsmicros.attribute_def_name_name2::text = 'etc:attribute:recentMemberships:grouperRecentMembershipsMicros'::text AND gaaagv_groupuuidfrom.attribute_def_name_name2::text = 'etc:attribute:recentMemberships:grouperRecentMembershipsGroupUuidFrom'::text AND gaaagv_includeeligible.attribute_def_name_name2::text = 'etc:attribute:recentMemberships:grouperRecentMembershipsIncludeCurrent'::text AND gaaagv_recentmembershipsmicros.value_integer > 0 AND gaaagv_recentmembershipsmicros.value_integer IS NOT NULL AND gaaagv_groupuuidfrom.value_string IS NOT NULL AND gaaagv_includeeligible.value_string IS NOT NULL AND (gaaagv_includeeligible.value_string::text = 'T'::text OR gaaagv_includeeligible.value_string::text = 'F'::text) AND gg.id::text = gaaagv_groupuuidfrom.value_string::text;

      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:
            1 Start watching this issue

            Dates

              Created:
              Updated: