Question

2
Replies
753
Views
jpbecker Member since 2005 28 posts
Wells Fargo N.A.
Posted: 3 years ago
Last activity: 3 years 7 months ago
Closed
Solved

TrueFalse property optimized as a varchar(5)

Why does the default optimization on my setup produce a varchar(5) when I optimize the TrueFalse property? Shouldn't this be a BOOLEAN?

I noted a problem after optimizing that a report written to filter based on this property's "IsFalse" condition was raising an exception. At first, I believed it to be a data type mismatch but upon restarting the system everything shook out - even though the TF property exists in a database column as a varchar(5). I realize there's probably some "Pega-plumbing" going on to resolve this issue, but does anyone know if this is always the case with optimization of TF properties and why?

***Updated by moderator: Lochan to update Categories; add SR Exists group tag***

Data Integration Reporting User Interface SR Exists
Moderation Team has archived post
Share this page LinkedIn