SQL issue between version 4 and version 5

[Mohamed Lrhazi]

ok, my bad!!!! version 5 had the incomplete sql template!!! sorry!

On Wed, Dec 18, 2024 at 4:27 PM Mohamed Lrhazi <lrhazi at cua.edu> wrote:

> oh wow, actually no, there is a difference in the log!!!!
>
> version 5 :
>
> shib-idp;idp-process.log;dev;nothing; SELECT 1 FROM PS_CX_TIMELYCAR_VW
> WHERE EMPLID = '$employeeID.get(0)'
> shib-idp;idp-process.log;dev;nothing; ) THEN 'true' ELSE 'false' END AS
> isTimelycareEligible
> shib-idp;idp-process.log;dev;nothing; FROM DUAL yields SELECT CASE WHEN
> EXISTS (
> shib-idp;idp-process.log;dev;nothing; SELECT 1 FROM PS_CX_TIMELYCAR_VW
> WHERE EMPLID = '1400621'
> shib-idp;idp-process.log;dev;nothing; ) THEN 'true' ELSE 'false' END AS
> isTimelycareEligible
> shib-idp;idp-process.log;dev;nothing; FROM DUAL
>
>
> version 4:
>
>
>
> shib-idp;idp-process.log;dev;nothing; SELECT 1 FROM PS_CX_TIMELYCAR_VW
> WHERE EMPLID = '$employeeID.get(0)'
> shib-idp;idp-process.log;dev;nothing; ) OR '$employeeID.get(0)' IN (
> '1400621', '1386568')
> shib-idp;idp-process.log;dev;nothing; THEN 'true' ELSE 'false' END AS
> isTimelycareEligible
> shib-idp;idp-process.log;dev;nothing; FROM DUAL yields SELECT CASE WHEN
> EXISTS (
> shib-idp;idp-process.log;dev;nothing; SELECT 1 FROM PS_CX_TIMELYCAR_VW
> WHERE EMPLID = '1400621'
> shib-idp;idp-process.log;dev;nothing; ) OR '1400621' IN ('1400621',
> '1386568')
> shib-idp;idp-process.log;dev;nothing; THEN 'true' ELSE 'false' END AS
> isTimelycareEligible
> shib-idp;idp-process.log;dev;nothing; FROM DUAL
>
> On Wed, Dec 18, 2024 at 4:12 PM Cantor, Scott <cantor.2 at osu.edu> wrote:
>
>> There's nothing different about the syntax for using dependencies in
>> query templates, but self-evidently if the log proves the query text is
>> resolved into the expected string it's not the problem.
>>
>> -- Scott
>>
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20241218/d9cd88a8/attachment.htm>