代码之家 › 专栏 › 技术社区 › massimogentilini

在TFS2010仓库中查找签入注释信息

tfs2010

2

massimogentilini · 技术社区 · 14 年前

我可以通过TFS浏览器看到这些信息,就像这样

image of tfs comments

select * from FactWorkItemChangeset fwics
join DimChangeset dcs on fwics.ChangesetSK=dcs.ChangesetSK
where dcs.ChangesetID = 145640

当做

2 回复 | 直到 4 年前

1

Henryk 14 年前

这个 变更集标题 Tfs中的字段_仓库.dbo.DimChangeset具有注释,尽管与变更集编号串联。您的查询确实返回字段。

2

0

massimogentilini 14 年前

示例查询:

select 
fwics.WorkItemID as [Work Item Id]
,dwi.System_Title as [Title]    
,dwi.System_WorkItemType as [Type]
,dcs.ChangesetID as ChangeSet_ID
,dcs.ChangesetTitle as [Comment]
,df.FileName as [FileName]
,df.FilePath as [Path]
,dd.DateTime as [CheckinDate]
,dp.Name as [Person]
from
DimChangeset dcs
join FactWorkItemChangeset fwics on dcs.ChangesetSK=fwics.ChangesetSK
join FactCodeChurn fcc on fwics.ChangesetSK=fcc.ChangesetSK
join DimFile df on fcc.FilenameSK=df.FileSK
join CurrentWorkItemView dwi on dwi.System_Id=fwics.WorkItemID
join DimDate dd on dd.DateSK=fcc.DateSK
join DimPerson dp on dp.PersonSK=dcs.CheckedInBySK
and fcc.TeamProjectSK = 80
order by [CheckinDate] desc