Question4Replies242Views Prakash. Member since 2012 6 posts Process 360 Posted: 4 years agoLast activity: 4 years 3 months ago Closed Solved NVL function in where clause of Report DefinitionHi,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 ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post 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. Accepted Solution Posted: 4 years agoCELLINGER Perficient replied to Prakash.Create a Function Alias rule in the Embed-UserFunction class. Look at existing rules for examples of how to set this up. Posted: 4 years agonistr PEGA replied to CELLINGERRefer https://pdn.pega.com/how-create-custom-sql-functions-reporting Posted: 4 years agoPrakash. Process 360 replied to nistrHi Chad,RajivThanks for your answers.But I was curios if there was any ootb way of doing this.Thanks,Bhanu Prakash. Posted: 4 years agonistr PEGA replied to Prakash.Currently there is no OOTB function available in report definition for this.