Child pages
  • UW-Madison Group Membership Delivery to Shibboleth

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

<DataConnector id="grouperDB" xsi:type="RelationalDatabase" readOnlyConnection="false" queryTimeout="PT3S">
<Dependency ref="uid"/>
<BeanManagedConnection>MyDataSource</BeanManagedConnection>
<QueryTemplate><![CDATA[
#if (${uid.size()} > 0)
SELECT DISTINCT grouper_memberships_lw_v.group_name
FROM grouper.grouper_aval_asn_group_v
JOIN grouper.grouper_memberships_lw_v
USING (group_id)
WHERE subject_id='$uid.get(0)'
AND grouper_aval_asn_group_v.attribute_def_name_name='etc:attribute:ShibEntityId:ShibEntityId'
AND (value_string = '$requestContext.getPeerEntityId()' OR value_string='DEFAULT')
AND grouper_aval_asn_group_v.enabled='T'
ORDER BY group_name ASC;
#else
SELECT 1
#end
]]></QueryTemplate>
</DataConnector>

...