Question

3
Replies
4350
Views
LahiruAgar Member since 2012 4 posts
EvonSys
Posted: 3 years ago
Last activity: 3 years 3 months ago
Closed
Solved

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

Data Integration Java and Activities
Moderation Team has archived post
Share this page LinkedIn