public WorkItemQueryResult GetWorkItemListWithWIQL(string pWiql, string pProjectName)
{
Wiql _wiql = new Wiql();
_wiql.Query = pWiql;
return(WitClient.QueryByWiqlAsync(_wiql, pProjectName).Result);
}
public void QueryByWiql()
{
Wiql wiql = new Wiql()
{
Query = $"Select [System.Id], [System.Title], [System.State] From WorkItems Where [System.WorkItemType] = '{DefaultWorkItemType.Name}' and [System.TeamProject] = '{TeamProject.Name}'"
};
var queryResults = WitClient.QueryByWiqlAsync(wiql).Result;
Console.WriteLine($"The wiql query returned {queryResults.WorkItems.Count()} results:");
var workItemList = queryResults.WorkItems.Select(wi => wi.Id);
string[] fields = new string[] { "System.Id", "System.Title" };
var workItems = WitClient.GetWorkItemsAsync(workItemList, fields).Result;
foreach (WorkItem wi in workItems)
{
Console.WriteLine($"WorkItem Id: '{wi.Id}' Title: '{wi.Fields["System.Title"]}'");
}
Console.WriteLine();
}