Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Bhanu Prakash G (Prakash.)
Process 360
Senior Consultant
Process 360
IN
Prakash. Member since 2012 6 posts
Process 360
Posted: Jun 27, 2016
Last activity: Jun 27, 2016
Posted: 27 Jun 2016 9:21 EDT
Last activity: 27 Jun 2016 10:26 EDT
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');

To see attachments, please log in.
Reporting

Accepted Solution

Posted: 8 years ago
Posted: 27 Jun 2016 10:09 EDT
Chad Ellinger (CELLINGER)
Perficient
Director
Perficient
US

Create a Function Alias rule in the Embed-UserFunction class. Look at existing rules for examples of how to set this up.

To see attachments, please log in.
Posted: 8 years ago
Posted: 27 Jun 2016 10:25 EDT
Bhanu Prakash G (Prakash.)
Process 360
Senior Consultant
Process 360
IN

Hi Chad,Rajiv

Thanks for your answers.But I was curios if there was any ootb way of doing this.

Thanks,

Bhanu Prakash.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice