Question

4
Replies
252
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,col2FROM testtable WHERE NVL(col3,'Not Registered')= NVL(Param.inputVal,'Not Registered');

Reporting
Moderation Team has archived post