<div dir="ltr">oh wow, actually no, there is a difference in the log!!!!<div><br></div><div>version 5 :<br><br><div style="line-height:18px"><div style="color:rgb(0,0,0);font-family:"Roboto Mono",Menlo,Monaco,"Courier New",monospace,Menlo,Monaco,"Courier New",monospace;font-size:12px;white-space:pre">shib-idp;idp-process.log;dev;nothing; <span style="color:rgb(0,0,255)">SELECT</span> <span style="color:rgb(9,134,88)">1</span> <span style="color:rgb(0,0,255)">FROM</span> PS_CX_TIMELYCAR_VW <span style="color:rgb(0,0,255)">WHERE</span> EMPLID = <span style="color:rgb(163,21,21)">'$employeeID.get(0)'</span></div><div style="color:rgb(0,0,0);font-family:"Roboto Mono",Menlo,Monaco,"Courier New",monospace,Menlo,Monaco,"Courier New",monospace;font-size:12px;white-space:pre">shib-idp;idp-process.log;dev;nothing; ) <span style="color:rgb(0,0,255)">THEN</span> <span style="color:rgb(163,21,21)">'true'</span> <span style="color:rgb(0,0,255)">ELSE</span> <span style="color:rgb(163,21,21)">'false'</span> <span style="color:rgb(0,0,255)">END</span> <span style="color:rgb(0,0,255)">AS</span> isTimelycareEligible</div><div style="color:rgb(0,0,0);font-family:"Roboto Mono",Menlo,Monaco,"Courier New",monospace,Menlo,Monaco,"Courier New",monospace;font-size:12px;white-space:pre">shib-idp;idp-process.log;dev;nothing; <span style="color:rgb(0,0,255)">FROM</span> DUAL yields <span style="color:rgb(0,0,255)">SELECT</span> <span style="color:rgb(0,0,255)">CASE</span> <span style="color:rgb(0,0,255)">WHEN</span> <span style="color:rgb(0,0,255)">EXISTS</span> (</div><div style="color:rgb(0,0,0);font-family:"Roboto Mono",Menlo,Monaco,"Courier New",monospace,Menlo,Monaco,"Courier New",monospace;font-size:12px;white-space:pre">shib-idp;idp-process.log;dev;nothing; <span style="color:rgb(0,0,255)">SELECT</span> <span style="color:rgb(9,134,88)">1</span> <span style="color:rgb(0,0,255)">FROM</span> PS_CX_TIMELYCAR_VW <span style="color:rgb(0,0,255)">WHERE</span> EMPLID = <span style="color:rgb(163,21,21)">'1400621'</span></div><div style="color:rgb(0,0,0);font-family:"Roboto Mono",Menlo,Monaco,"Courier New",monospace,Menlo,Monaco,"Courier New",monospace;font-size:12px;white-space:pre">shib-idp;idp-process.log;dev;nothing; ) <span style="color:rgb(0,0,255)">THEN</span> <span style="color:rgb(163,21,21)">'true'</span> <span style="color:rgb(0,0,255)">ELSE</span> <span style="color:rgb(163,21,21)">'false'</span> <span style="color:rgb(0,0,255)">END</span> <span style="color:rgb(0,0,255)">AS</span> isTimelycareEligible</div><div style="color:rgb(0,0,0);font-family:"Roboto Mono",Menlo,Monaco,"Courier New",monospace,Menlo,Monaco,"Courier New",monospace;font-size:12px;white-space:pre">shib-idp;idp-process.log;dev;nothing; <span style="color:rgb(0,0,255)">FROM</span> DUAL</div><div style="color:rgb(0,0,0);font-family:"Roboto Mono",Menlo,Monaco,"Courier New",monospace,Menlo,Monaco,"Courier New",monospace;font-size:12px;white-space:pre"><br></div><div style="color:rgb(0,0,0);font-family:"Roboto Mono",Menlo,Monaco,"Courier New",monospace,Menlo,Monaco,"Courier New",monospace;font-size:12px;white-space:pre"><br></div>version 4:</div></div><div style="line-height:18px"><br></div><div style="line-height:18px"><div style="color:rgb(0,0,0);font-family:"Roboto Mono",Menlo,Monaco,"Courier New",monospace,Menlo,Monaco,"Courier New",monospace;font-size:12px;line-height:18px;white-space:pre"><br><br><div>shib-idp;idp-process.log;dev;nothing; <span style="color:rgb(0,0,255)">SELECT</span> <span style="color:rgb(9,134,88)">1</span> <span style="color:rgb(0,0,255)">FROM</span> PS_CX_TIMELYCAR_VW <span style="color:rgb(0,0,255)">WHERE</span> EMPLID = <span style="color:rgb(163,21,21)">'$employeeID.get(0)'</span></div><div>shib-idp;idp-process.log;dev;nothing; ) <span style="color:rgb(0,0,255)">OR</span> <span style="color:rgb(163,21,21)">'$employeeID.get(0)'</span> <span style="color:rgb(0,0,255)">IN</span> (<span style="color:rgb(163,21,21)">'1400621'</span>, <span style="color:rgb(163,21,21)">'1386568'</span>)</div><div>shib-idp;idp-process.log;dev;nothing; <span style="color:rgb(0,0,255)">THEN</span> <span style="color:rgb(163,21,21)">'true'</span> <span style="color:rgb(0,0,255)">ELSE</span> <span style="color:rgb(163,21,21)">'false'</span> <span style="color:rgb(0,0,255)">END</span> <span style="color:rgb(0,0,255)">AS</span> isTimelycareEligible</div><div>shib-idp;idp-process.log;dev;nothing; <span style="color:rgb(0,0,255)">FROM</span> DUAL yields <span style="color:rgb(0,0,255)">SELECT</span> <span style="color:rgb(0,0,255)">CASE</span> <span style="color:rgb(0,0,255)">WHEN</span> <span style="color:rgb(0,0,255)">EXISTS</span> (</div><div>shib-idp;idp-process.log;dev;nothing; <span style="color:rgb(0,0,255)">SELECT</span> <span style="color:rgb(9,134,88)">1</span> <span style="color:rgb(0,0,255)">FROM</span> PS_CX_TIMELYCAR_VW <span style="color:rgb(0,0,255)">WHERE</span> EMPLID = <span style="color:rgb(163,21,21)">'1400621'</span></div><div>shib-idp;idp-process.log;dev;nothing; ) <span style="color:rgb(0,0,255)">OR</span> <span style="color:rgb(163,21,21)">'1400621'</span> <span style="color:rgb(0,0,255)">IN</span> (<span style="color:rgb(163,21,21)">'1400621'</span>, <span style="color:rgb(163,21,21)">'1386568'</span>)</div><div>shib-idp;idp-process.log;dev;nothing; <span style="color:rgb(0,0,255)">THEN</span> <span style="color:rgb(163,21,21)">'true'</span> <span style="color:rgb(0,0,255)">ELSE</span> <span style="color:rgb(163,21,21)">'false'</span> <span style="color:rgb(0,0,255)">END</span> <span style="color:rgb(0,0,255)">AS</span> isTimelycareEligible</div><div>shib-idp;idp-process.log;dev;nothing; <span style="color:rgb(0,0,255)">FROM</span> DUAL</div></div></div></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Wed, Dec 18, 2024 at 4:12 PM Cantor, Scott <<a href="mailto:cantor.2@osu.edu">cantor.2@osu.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">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.<br>
<br>
-- Scott<br>
<br>
<br>
</blockquote></div>