public void TestQuery1()
{
string orgUrl = Environment.GetEnvironmentVariable("VSTS_URL", EnvironmentVariableTarget.User);;
string pat = Environment.GetEnvironmentVariable("VSTS_PAT", EnvironmentVariableTarget.User);
string projectName = Environment.GetEnvironmentVariable("test_project", EnvironmentVariableTarget.User);
string queryContent = "SELECT [Id], [Title], [State] FROM workitems WHERE [Work Item Type] = 'Bug' AND [Assigned To] = @Me";
AzureDevOps.Data.Core core = new AzureDevOps.Data.Core(orgUrl, pat);
core.Connect();
JArray projects = core.GetProjects();
Guid projectID = Guid.Parse(projects.SelectToken($"$[?(@.Name == '{projectName}')].Id").ToString());
var result = core.RunQuery(projectID, queryContent);
Console.WriteLine(result);
}
public void TestWorkItems1()
{
string orgUrl = Environment.GetEnvironmentVariable("VSTS_URL", EnvironmentVariableTarget.User);
string pat = Environment.GetEnvironmentVariable("VSTS_PAT", EnvironmentVariableTarget.User);
string projectName = Environment.GetEnvironmentVariable("test_project", EnvironmentVariableTarget.User);
string queryContent = "SELECT [Id], [Task Due Date], [Parent] FROM workitems WHERE [Work Item Type] = 'Task' AND [Assigned To] = @Me AND [State] NOT IN ('Removed', 'Closed', 'Resolved')";
List <string> fields = new List <string>()
{
"System.Id",
"System.Title",
"System.State",
"System.IterationPath",
"System.WorkItemType",
"System.AssignedTo",
"System.CreatedDate",
"System.Tags",
"System.Parent",
"Microsoft.VSTS.Common.ActivatedDate",
"Microsoft.VSTS.Common.ResolvedDate",
"Microsoft.VSTS.Common.ResolvedBy",
"Microsoft.VSTS.Common.ClosedDate",
"Microsoft.VSTS.Common.ClosedBy",
"Microsoft.VSTS.Common.Priority",
"Microsoft.VSTS.Common.Severity",
"Microsoft.VSTS.Scheduling.RemainingWork",
"Microsoft.VSTS.Scheduling.OriginalEstimate",
"LinkDevAgile.Source",
"LinkDevAgile.TestingEnvironment",
"Custom.TaskDueDate"
};
AzureDevOps.Data.Core core = new AzureDevOps.Data.Core(orgUrl, pat);
core.Connect();
JArray projects = core.GetProjects();
Guid projectID = Guid.Parse(projects.SelectToken($"$[?(@.Name == '{projectName}')].Id").ToString());
var resultWorkItems = core.RunQuery(projectID, queryContent);
List <int> workItemsIDs = new List <int>();
List <int> parentsIDs = new List <int>();
foreach (var item in resultWorkItems["WorkItems"].Children())
{
workItemsIDs.Add(item.Value <int>("Id"));
}
var result = core.GetWorkItems(projectID, workItemsIDs, fields);
foreach (var item in result)
{
int parentId = int.Parse(item["Fields"]["System.Parent"].ToString());
if (parentsIDs.IndexOf(parentId) > -1)
{
parentsIDs.Add(parentId);
}
}
var resultParents = core.GetWorkItems(projectID, parentsIDs, new List <String>()
{
"System.Id", "System.WorkItemType", "System.Title"
});
Console.WriteLine(resultParents);
Console.WriteLine(result);
}