Question
Passing Parameters to Function Alias
Hi All,
I have a Report Defination and I am using Function Alias in that.
I have mentioned NULL in parameter <<See PassingParameter.png in attachments>>. But If I trace it "'NULL'" its taking it as string <<See TracerParameter.png in attachments>>.I think pega is adding "' PARAMETER '" (Double Qoutes) to string passed.
Now I need Regular Expression to compare "'NULL'" in my soure code of Function Alias.
I used below code but below highlighted line is failing.
<pega:choose>
<pega:when test=".pyParameters(3).pyParametersParamValue == '\"NULL\"'">
(CASE WHEN ({1} IS NULL)
</pega:when>
<pega:otherwise>
(CASE WHEN ({1}={3})
</pega:otherwise>
</pega:choose>
Now I want is how do we write code in when condition to match "'NULL'" value instead of NULL in JSP.
Since you say it is failing, can you share the error you are getting?
-- I'm not getting any error.. If you observe the code
<pega:choose>
<pega:when test=".pyParameters(3).pyParametersParamValue == '\"NULL\"'"> -- When cond will return false
(CASE WHEN ({1} IS NULL) -- SKIP
</pega:when>
<pega:otherwise> -- If when condition return false below statement will get executed.
(CASE WHEN ({1}={3})
</pega:otherwise>
</pega:choose>
Also, did you try using the test condition without double quotes around NULL? -- I'm passing without double qoutes but pega is adding double qoutes while execution.
Alternatively, instead of passing the string NULL, could you pass an empty string to generate IS NULL in the query?
I tried passing empty but I got error while saving the rule.
Accepted Solution
Also, did you try using the test condition without double quotes around NULL? -- I'm passing without double qoutes but pega is adding double qoutes while execution.
I was suggesting that your when condition could be modified to check without quotes.
An alternative could be to move around your parameters so that this is not the last parameter and then pass an empty string.
Since you say it is failing, can you share the error you are getting?
Also, did you try using the test condition without double quotes around NULL?
Alternatively, instead of passing the string NULL, could you pass an empty string to generate IS NULL in the query?