Data Warehouse table with null values allowed
![]()
Hi guys,
I have written a plug-in to extend the data warehouse with a some custom fields. For my new DW table I have followed the example "Extending the Data Warehouse". Now I want to allow null values for some of my columns, how can I do? Must I set some value FieldKind or FieldFlags? If yes, which? Thanks Andrea |
One answer
![]()
Andrea, in 2.0, we do collect custom work item fields in the data warehouse.
In general, to keep things simple, we did not allow nulls for fields. For string fields we store "Unassigned" instead of null. We also did this to avoid differences on how various DBs behave with respect to null values. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.