TFS (Team Foundation Server)是微软提供的应用程序生命周期管理工具,现在已演变为Azure DevOps Server。工作项(Work Item)是TFS中用于跟踪任务、缺陷、用户故事等的基本单位。
SELECT [System.Id], [System.Title], [System.State], [System.ChangedDate], [System.ClosedBy]
FROM WorkItems
WHERE [System.ClosedBy] = '具体人员姓名'
AND [System.State] = 'Closed'
ORDER BY [System.ChangedDate] DESC
如果需要编程查询,可以使用TFS REST API:
using Microsoft.TeamFoundation.WorkItemTracking.WebApi;
using Microsoft.VisualStudio.Services.Common;
// 连接TFS
VssConnection connection = new VssConnection(new Uri("TFS服务器地址"), new VssCredentials());
WorkItemTrackingHttpClient workItemTrackingClient = connection.GetClient<WorkItemTrackingHttpClient>();
// 构建WIQL查询
string wiqlQuery = "SELECT [System.Id], [System.Title] FROM WorkItems WHERE [System.ClosedBy] = '具体人员姓名' AND [System.State] = 'Closed'";
// 执行查询
var queryResult = await workItemTrackingClient.QueryByWiqlAsync(new Microsoft.TeamFoundation.WorkItemTracking.WebApi.Models.Wiql() { Query = wiqlQuery });
// 获取工作项详情
if (queryResult.WorkItems.Any())
{
var ids = queryResult.WorkItems.Select(wi => wi.Id).ToArray();
var workItems = await workItemTrackingClient.GetWorkItemsAsync(ids);
foreach (var workItem in workItems)
{
Console.WriteLine($"ID: {workItem.Id}, Title: {workItem.Fields["System.Title"]}");
}
}
问题1:查询不到结果
问题2:权限不足
问题3:查询结果不完整
通过以上方法,您可以有效地查询特定人员在TFS中关闭的工作项,并根据需要进行进一步的分析和处理。
没有搜到相关的文章