Getting WorkItems by Project Name from TfsWorkItemTracking database

Hello Faraz,

I am assuming you are using WorkItem Object Model to get the work items. One easy way to get the work items in each project would be

WorkItemStore store =newWorkItemStore("<Server_Name>");

string query ="SELECT [System.Id], [System.Title] FROM WorkItems WHERE [System.TeamProject] = @project";

System.Collections.Hashtable context =new System.Collections.Hashtable();

context.Add("project","<project_name>");

store.Query(query, context);

If you want it based on a single project then it can be much more easy, just put the project name in place of @project, it would look like

WorkItemStore store =newWorkItemStore("<Server_Name>");

string query ="SELECT [System.Id], [System.Title] FROM WorkItems WHERE [System.TeamProject] = '<Project_Name>'";

store.Query(query, context);

Hope this helps,

SmithaSSaligrama at 2007-10-8 >

Hi,

This is a worst pratice, you should consider the TFS Databases like "Black Box". Data Schema could be updated in the futures versions and a lot of your code would not work anymore.

You should only ask TFS server using the API.

mathieu.szablowski at 2007-10-8 >

Updating values in database is tricker than it seems. Here are some questions to think about: If you do update the value, do you expect it to be updated only on latest revision or on all old revisions? If you update it on specific existing revision, during auditing it seems as if the actual user who created the revision added that value when in fact an admit directly changed the db. Sometimes we do cache strings and place ids in table to reduce data size, in which case it is tricky to get the string id. For various reasons like this, changing data directly is discouraged and will void support.

You can update fields of many items easily by exporting into excel and then bulk changing field values, it requires no coding.

NarenDatha-MSFT at 2007-10-8 >