Venkata Vikram Dabbugottu (VenkataVikramD)
Academic works
Pega Developer
Academic works
VenkataVikramD Member since 2019 2 posts
Academic works
Posted: June 12, 2020
Last activity: June 15, 2020
Posted: 12 Jun 2020 9:08 EDT
Last activity: 15 Jun 2020 2:56 EDT

Report definition is sending a null value when replace function is used


My report definition must fetch the information based on the person number and the format of the person number can be YYYYMMDD-NNNN or YYYYMMDDNNNN.

In the report definition am using replace function to replace "-" with empty space like "" and the string changes to YYYYMMDDNNNN. But when am not passing any string through the report definition the SQL query is generates as:

select * from tablename WHERE ( ( "CustomerInfo"."PERSONALNUMBER" = REPLACE(? ,? ,'') ) ).

The question is there’s any possibility in pega report definition to not send a "null” when the string is not passed. In my case I want the SQL query as:

select * from tablename.   


***Edited by Moderator Kayla to update Platform Capability tags****

Pega Platform 8.3.1 Reporting Financial Services
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.