Question
AreteansTech
AU
Last activity: 11 Jun 2017 6:16 EDT
SQL Function Alias - Use function and pass param value
Greetings!
I'm trying to implement a SQL function alias that calls a java function. I have used this function alias in a report definition. And I'm passing a string parameter to it. In the function alias I need to evaluate this param value (by passing this to the function). I'm using the following condition in Java to do so;
<%
if (ruleset_library.FunctionName(tools.getStepPage().getString(".pyParameters(1).pyParametersParamValue")) == "Something") {
%>
The ".pyParameters(1).pyParametersParamValue" contains the column name, and not its actual value.
Is there a way to achieve this? Any help is appreciated.
Thanks in advance.
Regards,
Lahiru.
***Moderator Edit: Vidyaranjan | Updated Categories***
Accepted Solution
Pegasystems Inc.
US
Rett has it right. SQL functions are used to generate the SQL string used to retrieve the data from the data base. I'm not sure what you're trying to accomplish, but your approach won't work. Have you considered post processing with a data page? Or craft the SQL function to manipulate the data, rather than relying on java to do so?
Pegasystems Inc.
US
Are you referring to Rule-Alias-Functions created in the Embed-UserFunction class?
If so, I do not believe what you are trying to do is supported. The intent for this feature is to create custom/complex SQL to be used in your report. I do not believe we support trying to put Java in there.
I'll need a reporting SME to confirm or correct me and clarify here.
Accepted Solution
Pegasystems Inc.
US
Rett has it right. SQL functions are used to generate the SQL string used to retrieve the data from the data base. I'm not sure what you're trying to accomplish, but your approach won't work. Have you considered post processing with a data page? Or craft the SQL function to manipulate the data, rather than relying on java to do so?