Boolean fields show as -1 for TRUE
Article ID: KB0078856
Updated On:
| Products | Versions |
|---|---|
| TIBCO Scribe Insight | 7.9.0, 7.9.1, 7.9.2 |
Description
In my TIBCO Scribe® Insight DTS, when I map a Boolean field from my CRM source to a SQL target database, the value for TRUE results in -1 when I expect the value to be 1.
This behavior is related to the TIBCO Scribe® Insight core product and is not limited to the Dynamics CRM Adapter. The underlying architecture of TIBCO Scribe® Insight interprets Boolean FALSE value as 0, and any non-zero value as TRUE. The objects and languages used in the TIBCO Scribe® Insight product have limitations with Boolean values, and typically
TRUE is -1. Best practice is to use a formula when creating the data link to ensure the Target field is set to 1 or 0.
This behavior is related to the TIBCO Scribe® Insight core product and is not limited to the Dynamics CRM Adapter. The underlying architecture of TIBCO Scribe® Insight interprets Boolean FALSE value as 0, and any non-zero value as TRUE. The objects and languages used in the TIBCO Scribe® Insight product have limitations with Boolean values, and typically
TRUE is -1. Best practice is to use a formula when creating the data link to ensure the Target field is set to 1 or 0.
Issue/Introduction
TIBCO Scribe® Insight sometimes displays a Boolean source field as -1 for value TRUE.
Resolution
Use the following formula to set the Target field to 1 or 0, not -1: IF(S3=0, FALSE( ), TRUE( ))
Feedback
Yes
No
Powered by
