Question

3
Replies
4478
Views
Close popover
Virendranath Alahakoon (LahiruAgar)
AreteansTech
Lead System Architect
AreteansTech
AU
LahiruAgar Member since 2012 4 posts
AreteansTech
Posted: May 30, 2017
Last activity: June 11, 2017
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.