It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×10,826

question asked: Jul 28 '09, 9:31 a.m.
question was seen: 6,378 times
last updated: Jul 28 '09, 9:31 a.m.

Related questions

FAQ - How this Forum works

Data Warehouse table with null values allowed

0
Andrea Ianni (161●19●16) | asked Jul 28 '09, 9:31 a.m.
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

Most liked answers|Newest answers ↑|Oldest answers

0
permanent link
Rafik Jaouani (5.0k●1●6) | answered Jul 30 '09, 3:54 p.m.
JAZZ DEVELOPER
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

Register or to post 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.