Welcome to the Jazz Community Forum
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
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.
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.