SQL issue between version 4 and version 5

[Mohamed Lrhazi]

No, it is all my fault.

this was the sql in my version 4:

```
<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>
```


and this was my sql in version 5:

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


I forgot I did not move a "slight" change to the sql from v4 to v5.




On Wed, Dec 18, 2024 at 5:02 PM Cantor, Scott <cantor.2 at osu.edu> wrote:

> Leaving aside whatever monstrosity is screwing with your logs making them
> unreadable, Velocity echoes unresolved variable substitutions by default,
> always has. A property was added to toggle on exception throwing instead.
>
> It's just telling you there is no employeeID attribute there to build a
> statement on.
>
> -- Scott
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20241218/027cd725/attachment.htm>