cancel
Showing results for 
Search instead for 
Did you mean: 

Add Null value to LoV and use that to be default value

0 Kudos

Hi All,

I have a prompt that should display null when no value is selected and even if the default value is set, the dataset should not be affected ie query should not be generated as date =null. The datatype of the prompt should be date.


First, the dataset did not have null value. I used union to add null and when previewing it null did not come up in the list of values. Second, the null value as default value did not work as the query was affected and it did not fetch any records.

Could you pls let me know if there is a workaround for this?

Regards,

Sahana Thangaraja

Accepted Solutions (0)

Answers (0)