Hi!

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****