SQL issue between version 4 and version 5

[Mohamed Lrhazi]

Hello,


I am encountering an issue with the following code within an attribute
definition:

```
<QueryTemplate>
<![CDATA[
SELECT CASE WHEN EXISTS (
SELECT 1 FROM PS_CX_TIMELYCAR_VW WHERE EMPLID = '$employeeID.get(0)'
) OR '$employeeID.get(0)' IN ('1400621', '1386568')
THEN 'true' ELSE 'false' END AS isTimelycareEligible
FROM DUAL
]]>
</QueryTemplate>
```

This code functions as expected in Shibboleth version 4, returning 'true'
for a user with emplid 1400621. However, in Shibboleth version 5, it
returns 'false' for the same user.

Any idea what would be causing this? maybe $employeeID.get(0)' does not
work the same way in version 5 ?

Thank you.
Mohamed
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20241218/967ecbe2/attachment.htm>