<div dir="ltr">To clarify, this works:<div><br></div><div><div style="color:rgb(51,51,51);background-color:rgb(253,246,227);font-family:Menlo,Monaco,"Courier New",monospace;font-size:12px;line-height:18px;white-space:pre"><br><div> <<span style="color:rgb(38,139,210)">AttributeDefinition</span> <span style="color:rgb(147,161,161)">id</span>=<span style="color:rgb(42,161,152)">"isPatron"</span> <span style="color:rgb(147,161,161)">xsi:type</span>=<span style="color:rgb(42,161,152)">"Mapped"</span>></div><div> <<span style="color:rgb(38,139,210)">InputDataConnector</span> <span style="color:rgb(147,161,161)">ref</span>=<span style="color:rgb(42,161,152)">"oracledbcf_csprd_wrlc"</span> <span style="color:rgb(147,161,161)">attributeNames</span>=<span style="color:rgb(42,161,152)">"cx_patron_type"</span>/></div><div> <<span style="color:rgb(38,139,210)">DefaultValue</span>>false</<span style="color:rgb(38,139,210)">DefaultValue</span>></div><div> <<span style="color:rgb(38,139,210)">ValueMap</span>></div><div> <<span style="color:rgb(38,139,210)">ReturnValue</span>>true</<span style="color:rgb(38,139,210)">ReturnValue</span>></div><div> <<span style="color:rgb(38,139,210)">SourceValue</span> <span style="color:rgb(147,161,161)">partialMatch</span>=<span style="color:rgb(42,161,152)">"false"</span>>.+</<span style="color:rgb(38,139,210)">SourceValue</span>></div><div> </<span style="color:rgb(38,139,210)">ValueMap</span>></div><div> </<span style="color:rgb(38,139,210)">AttributeDefinition</span>></div><div> <<span style="color:rgb(38,139,210)">DataConnector</span> <span style="color:rgb(147,161,161)">xsi:type</span>=<span style="color:rgb(42,161,152)">"RelationalDatabase"</span> <span style="color:rgb(147,161,161)">id</span>=<span style="color:rgb(42,161,152)">"oracledbcf_csprd_wrlc"</span>></div><div> <<span style="color:rgb(38,139,210)">BeanManagedConnection</span>>OracleDataSourceCSPRD</<span style="color:rgb(38,139,210)">BeanManagedConnection</span>></div><div> <<span style="color:rgb(38,139,210)">InputAttributeDefinition</span> <span style="color:rgb(147,161,161)">ref</span>=<span style="color:rgb(42,161,152)">"employeeID"</span> /></div><div> <<span style="color:rgb(38,139,210)">QueryTemplate</span>></div><div> <span style="color:rgb(42,161,152)"><![CDATA[</span></div><div><span style="color:rgb(42,161,152)"> select cx_patron_type</span></div><div><span style="color:rgb(42,161,152)"> from sysadm.ps_cx_alma_saml</span></div><div><span style="color:rgb(42,161,152)"> where emplid='$employeeID.get(0)'</span></div><div><span style="color:rgb(42,161,152)"> ]]></span></div><div> </<span style="color:rgb(38,139,210)">QueryTemplate</span>></div><div> <<span style="color:rgb(38,139,210)">Column</span> <span style="color:rgb(147,161,161)">columnName</span>=<span style="color:rgb(42,161,152)">"CX_PATRON_TYPE"</span> <span style="color:rgb(147,161,161)">attributeID</span>=<span style="color:rgb(42,161,152)">"cx_patron_type"</span> /></div><div> </<span style="color:rgb(38,139,210)">DataConnector</span>></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Aug 26, 2021 at 7:42 PM Mohamed Lrhazi <<a href="mailto:lrhazi@cua.edu">lrhazi@cua.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hmmm... looks like the column name is case sensitive! It needed to be <span style="color:rgb(0,0,0);font-family:monospace">CX_PATRON_TYPE!</span><br><div><span style="color:rgb(0,0,0);font-family:monospace"><br></span></div><div><span style="color:rgb(0,0,0);font-family:monospace"><br></span></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Aug 26, 2021 at 7:23 PM Mohamed Lrhazi <<a href="mailto:lrhazi@cua.edu" target="_blank">lrhazi@cua.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hello all,<div><br></div><div>Why is this returning "false" when am expecting "true" :<div><br></div><div><br><div><div style="color:rgb(51,51,51);background-color:rgb(253,246,227);font-family:Menlo,Monaco,"Courier New",monospace;font-size:12px;line-height:18px;white-space:pre-wrap"><div><<span style="color:rgb(38,139,210)">AttributeDefinition</span> <span style="color:rgb(147,161,161)">id</span>=<span style="color:rgb(42,161,152)">"isPatron"</span> <span style="color:rgb(147,161,161)">xsi:type</span>=<span style="color:rgb(42,161,152)">"Mapped"</span>></div><div> <<span style="color:rgb(38,139,210)">InputDataConnector</span> <span style="color:rgb(147,161,161)">ref</span>=<span style="color:rgb(42,161,152)">"oracledbcf_csprd_wrlc"</span> <span style="color:rgb(147,161,161)">attributeNames</span>=<span style="color:rgb(42,161,152)">"cx_patron_type"</span>/></div><div> <<span style="color:rgb(38,139,210)">DefaultValue</span>>false</<span style="color:rgb(38,139,210)">DefaultValue</span>></div><div> <<span style="color:rgb(38,139,210)">ValueMap</span>></div><div> <<span style="color:rgb(38,139,210)">ReturnValue</span>>true</<span style="color:rgb(38,139,210)">ReturnValue</span>></div><div> <<span style="color:rgb(38,139,210)">SourceValue</span>>.+</<span style="color:rgb(38,139,210)">SourceValue</span>></div><div> </<span style="color:rgb(38,139,210)">ValueMap</span>></div><div> </<span style="color:rgb(38,139,210)">AttributeDefinition</span>></div><div> <<span style="color:rgb(38,139,210)">DataConnector</span> <span style="color:rgb(147,161,161)">xsi:type</span>=<span style="color:rgb(42,161,152)">"RelationalDatabase"</span> <span style="color:rgb(147,161,161)">id</span>=<span style="color:rgb(42,161,152)">"oracledbcf_csprd_wrlc"</span>></div><div> <<span style="color:rgb(38,139,210)">BeanManagedConnection</span>>OracleDataSourceCSPRD</<span style="color:rgb(38,139,210)">BeanManagedConnection</span>></div><div> <<span style="color:rgb(38,139,210)">InputAttributeDefinition</span> <span style="color:rgb(147,161,161)">ref</span>=<span style="color:rgb(42,161,152)">"employeeID"</span> /></div><div> <<span style="color:rgb(38,139,210)">QueryTemplate</span>></div><div> <span style="color:rgb(42,161,152)"><![CDATA[</span></div><div><span style="color:rgb(42,161,152)"> select cx_patron_type</span></div><div><span style="color:rgb(42,161,152)"> from sysadm.ps_cx_alma_saml</span></div><div><span style="color:rgb(42,161,152)"> where emplid='$employeeID.get(0)'</span></div><div><span style="color:rgb(42,161,152)"> ]]></span></div><div> </<span style="color:rgb(38,139,210)">QueryTemplate</span>></div><div> <<span style="color:rgb(38,139,210)">Column</span> <span style="color:rgb(147,161,161)">columnName</span>=<span style="color:rgb(42,161,152)">"cx_patron_type"</span> <span style="color:rgb(147,161,161)">attributeID</span>=<span style="color:rgb(42,161,152)">"cx_patron_type"</span> /></div><div> </<span style="color:rgb(38,139,210)">DataConnector</span>></div></div></div><div><br></div><div>In the log I see this:</div><div><font face="monospace"><br></font></div><div><font face="monospace">- DEBUG [net.shibboleth.idp.attribute.resolver.AbstractDataConnector:229] - Data Connector 'oracledbcf_csprd_wrlc': Attribute 'CX_PATRON_TYPE': Values '[StringAttributeValue{value=custaf}]'<br></font></div><div><font face="monospace">...</font></div><div><font face="monospace">- 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<br>- DEBUG [net.shibboleth.idp.attribute.resolver.AbstractAttributeDefinition:139] - Attribute Definition 'isPatron': produced an attribute with the following values [StringAttributeValue{value=false}]<br></font><br></div></div></div></div>
</blockquote></div>
</blockquote></div>