Edwin Castro

I removed the Triage field from work item types where we don't need a Triage field. We were only expecting to see work item types that still have the Triage field when we run the Triage report but we still see work items from types that do not have the Triage field any more. When we query using Team Explorer we see no data in the Triage field but that matches the behavior we see when we look at fields that don't exist.

I'm trying to understand why we see those work items that no longer have a triage field. When I use the client object model and do a workItem.Fields.Contains("Microsoft.VSTS.Common.Triage") I get false for those work items showing up in the Triage report. Any thoughts


Re: Team Foundation Server - Work Item Tracking Removed Field from WIT and Report Still Shows data

Tiago Pascoal

I'm sorry but i'm not following you.

When you say report, is it a Reporting Services report or a query result





Re: Team Foundation Server - Work Item Tracking Removed Field from WIT and Report Still Shows data

Edwin Castro

My apologies.

The Triage report (reporting services) is showing non-Closed work items that used to have the Triage field in the work item type definition.

When I run team explorer query to view these same work items I don't see any data in the Triage column.

Please let me know if anything else is still unclear.




Re: Team Foundation Server - Work Item Tracking Removed Field from WIT and Report Still Shows data

Tiago Pascoal

Perfectly clear now.

You have to explain it in a easy way, or i won't understand. It's a "it's not you it's me kind of thing" :-)

You are talking about work items that have been exported to the Datawarehouse before the definition was changed right

These kind of changes don't have retroactive effects. Neither addition or removal of fields are exported to work items already on the datawarehouse. (new work items won't have the fields though)







Re: Team Foundation Server - Work Item Tracking Removed Field from WIT and Report Still Shows data

Edwin Castro

That makes sense. Is there a way to remove that data so that it doesn't pollute the Triage report




Re: Team Foundation Server - Work Item Tracking Removed Field from WIT and Report Still Shows data

Tiago Pascoal

AFAIK there is no way.

Unless you direct fiddle with the warehouse data. Which off course is not recommended at all.

A cleaner but not very acceptable workaround would be to change the triage report to explicitily exclude work item types that you wish to exclude. Not very nice and a mantenaince headache.


I would recommend that you post this question on the warehouse forum. There are probably some people over there that can help you. (or say that definatevely there isn't a way :-))