I want to display a dropdown of project names in my customized workitem type. The list of project names will increase over time. We are using one Team Project to store all our projects.

Currently I have dumped all our existing project names into a GlobalList. However, maintenance of this is going to be very unfriendly for admin users (who are not technical). Also, there is no provision to correct a project name if one is entered incorrectly.

I think I have two options:

1. create a custom control to pick up the relevant project names from a database and save the project id field to the workitem. All addition or editing of project names can be done via this table with a UI.
2. create a UI that manipulates the TFSWorkItemTracking database directly

To do the latter option, I will need to know more about how the Constants table works, where the Global List data seems to be stored. It is not obvious how the Global List data is delimited within the table (I see "*GlobalListName" followed by "GlobalListValue" entries in subsequent records, but nothing to indicate when the list data stops).

Suggestions, anyone?

Hi Luis,

I would love to give SP1 a shot, but have found that installing it has NOT updated the relevant dlls to the correct version (even though the VS about box shows the right version). I seem to be stuck with custom controls because of that, which is very annoying.

I haven't looked into the manipulation of Global Lists via the object model, I will go and check that out.

Cheers.