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

Report

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

Accepted Solution

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

Create a Function Alias rule in the Embed-UserFunction class. Look at existing rules for examples of how to set this up.
Posted: 7 years ago
Posted: 27 Jun 2016 10:25 EDT
Bhanu Prakash G (Prakash.) Process 360 Senior Consultant
Process 360
IN
Report

Hi Chad,Rajiv

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

Thanks,

Bhanu Prakash.
Posted: 7 years ago
Posted: 27 Jun 2016 10:26 EDT
Rajiv Nistala (nistr) Senior Manager - Engineering
Pegasystems
IN
Report

Currently there is no OOTB function available in report definition for this.

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