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;