Mapped AttributeDefinition question

[Mohamed Lrhazi]

To clarify, this works:


<AttributeDefinition id="isPatron" xsi:type="Mapped">
<InputDataConnector ref="oracledbcf_csprd_wrlc" attributeNames=
"cx_patron_type"/>
<DefaultValue>false</DefaultValue>
<ValueMap>
<ReturnValue>true</ReturnValue>
<SourceValue partialMatch="false">.+</SourceValue>
</ValueMap>
</AttributeDefinition>
<DataConnector xsi:type="RelationalDatabase" id="oracledbcf_csprd_wrlc">
<BeanManagedConnection>OracleDataSourceCSPRD</BeanManagedConnection>
<InputAttributeDefinition ref="employeeID" />
<QueryTemplate>
<![CDATA[
select cx_patron_type
from sysadm.ps_cx_alma_saml
where emplid='$employeeID.get(0)'
]]>
</QueryTemplate>
<Column columnName="CX_PATRON_TYPE" attributeID="cx_patron_type" />
</DataConnector>

On Thu, Aug 26, 2021 at 7:42 PM Mohamed Lrhazi <lrhazi at cua.edu> wrote:

> Hmmm... looks like the column name is case sensitive! It needed to be
> CX_PATRON_TYPE!
>
>
>
> On Thu, Aug 26, 2021 at 7:23 PM Mohamed Lrhazi <lrhazi at cua.edu> wrote:
>
>> Hello all,
>>
>> Why is this returning "false" when am expecting "true" :
>>
>>
>> <AttributeDefinition id="isPatron" xsi:type="Mapped">
>> <InputDataConnector ref="oracledbcf_csprd_wrlc" attributeNames=
>> "cx_patron_type"/>
>> <DefaultValue>false</DefaultValue>
>> <ValueMap>
>> <ReturnValue>true</ReturnValue>
>> <SourceValue>.+</SourceValue>
>> </ValueMap>
>> </AttributeDefinition>
>> <DataConnector xsi:type="RelationalDatabase" id="oracledbcf_csprd_wrlc">
>> <BeanManagedConnection>OracleDataSourceCSPRD</BeanManagedConnection>
>> <InputAttributeDefinition ref="employeeID" />
>> <QueryTemplate>
>> <![CDATA[
>> select cx_patron_type
>> from sysadm.ps_cx_alma_saml
>> where emplid='$employeeID.get(0)'
>> ]]>
>> </QueryTemplate>
>> <Column columnName="cx_patron_type" attributeID="cx_patron_type" />
>> </DataConnector>
>>
>> In the log I see this:
>>
>> - DEBUG [net.shibboleth.idp.attribute.resolver.AbstractDataConnector:229]
>> - Data Connector 'oracledbcf_csprd_wrlc': Attribute 'CX_PATRON_TYPE':
>> Values '[StringAttributeValue{value=custaf}]'
>> ...
>> - DEBUG
>> [net.shibboleth.idp.attribute.resolver.ad.mapped.impl.MappedAttributeDefinition:212]
>> - Attribute Definition isPatron: Default value of
>> StringAttributeValue{value=false} added as the value for this attribute
>> - DEBUG
>> [net.shibboleth.idp.attribute.resolver.AbstractAttributeDefinition:139] -
>> Attribute Definition 'isPatron': produced an attribute with the following
>> values [StringAttributeValue{value=false}]
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20210826/6c728a01/attachment.htm>