TFS 2015(集合数据库)中缺少表 WorkItemsLatest (TFS 2010) [英] Table WorkItemsLatest (TFS 2010) missing in TFS 2015 (Collection Database)
问题描述
我们最近从 TFS 2010 迁移到 TFS 2015，发现一些报告服务不再工作.
We recently migrated from TFS 2010 to TFS 2015 and came across that some of the reporting services are not working anymore.
我们创建的视图之一是从WorkItemsLatest"表中提取各种信息(WorkItem State、Title、Fld10118)，但是，检查 TFS 2015 的集合数据库表明 TFS 2015 集合中没有更多的WorkItemsLatest"表数据库.
One of the view we created was pulling various information (WorkItem State, Title,Fld10118) from "WorkItemsLatest" table, however, checking the collection database of TFS 2015 indicates that there is no more "WorkItemsLatest" table in TFS 2015 collection database.
如果您能建议如何在 TFS 2015 集合数据库中获取上述字段，我将不胜感激.我了解 Microsoft 不支持操作数据库并鼓励从 Warehouse 数据库中检索数据，但是，我们希望检索此数据并将在未来分配一些开发时间以确保从 Warehouse 数据库中检索数据.
I would appreciate if you can advise how to get above mentioned fields in TFS 2015 collection database. I understand that the operational databases are not supported by Microsoft and encourages to retrieve data from Warehouse database, however, we would like to retrieve this data and will allocate some development time in the future to ensure that data is retrieved from the Warehouse database.
推荐答案
警告
即使您自己已经提到了这一点，直接查询数据库表可能会导致更新之间的功能中断.随着最近工作项空间的大量流失(新的模板自定义功能登陆 VSTS，并且可能会出现在 TFS vNext 和新的工作项表单中)，预计这些项目在不久的将来会不断变化.
WARNING
Even though you've already mentioned this yourself, querying the database tables directly can lead to breaking functionality between updates. With the recent amount of churn in the work item space (new template customization features landing on VSTS and probably coming to TFS vNext and the new workitem form), expect these items to keep changing in the near future.
因此，您可能正在寻找以下两种视图:
So, you're probably looking for the following two views:
[Tfs_DefaultCollection].[dbo].[vw_denorm_WorkItemCoreLatest][Tfs_DefaultCollection].[dbo].[vw_denorm_WorkItemCustomLatest]
并将它们与 tbl_Field 结合起来，以便能够识别哪个自定义字段 ID 与哪个字段名称匹配.
And join them with tbl_Field to be able to identify which Custom Field ID matches which Field Name.
这篇关于TFS 2015(集合数据库)中缺少表 WorkItemsLatest (TFS 2010)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
