Question

4
Replies
263
Views
Close popover
Bhanu Prakash G (Prakash.)
Process 360
Senior Consultant
Process 360
IN
Prakash. Member since 2012 6 posts
Process 360
Posted: June 27, 2016
Last activity: June 27, 2016
Closed
Solved

NVL function in where clause of Report Definition

Hi,

How do I configure the report definition to generate an sql like below:

SELECT col1,col2 FROM testtable WHERE NVL(col3,'Not Registered') = NVL(Param.inputVal,'Not Registered');

Reporting
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.