Support Article
Report Definition does not display Blank, False, and True Values
KCP-352
Summary
Boolean VARCHAR2 property has three values: Blank, False, and True.
On using an exposed column in a report definition, 'blank' values display as False. However, if a report is exported, the 'blank' values display correctly as blank (unique from 'False').
Error Messages
Not Applicable
STEPS TO REPRODUCE
Unknown
ROOT CAUSE
Boolean treats Null, Undefined, 0, and Empty values as Null.
Resolution
Here's the explanation for the reported behavior:
Since the property is defined as Boolean and the value is left Empty, the value is treated as False by default.
Published December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.