Introspect Sharepoint Calculated Columns to datatypes other than Boolean
Article ID: KB0081424
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.4.00.01 |
Description
Native Sharepoint data adapter is always introspecting calculated column as BOOLEAN data type. Is it possible to change the default setting to some other datatype.
Issue/Introduction
Native Sharepoint data adapter is always introspecting calculated column as BOOLEAN data type. Is it possible to change the default setting to some other datatype.
Resolution
Within the Sharepoint datasource in TDV, there is a property called “Calculated Datatype”. This drop down lets you chose how the Calculated columns are introspected within DV. This drop down has valid values of:
“Boolean”
“DATE”
“DATETIME”
“DOUBLE”
“INTEGER”
“STRING”
The only caveat with this setting is - it will introspect all the Calculated columns as the datatype setup here. If you notice "BOOLEAN" all the time, that's because it is the default setting.
There is a governor which will overwrite this setting. If you set the "Other” field in the datasource to -> Calculated Data Type=“”, it will introspect the columns as per it’s original datatype in the Sharepoint site.
Feedback
Yes
No
Powered by
