Question
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***
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.