无法访问分配给Azure DevOps工作项的字段

Question

我正在visual中创建一个控制台应用程序，以便从Azure DevOps项目获得工作项的详细信息。我无法访问工作项的AssignedTo字段。

我尝试使用Microsoft中的代码查询带有某些更改的工作项，并在尝试访问AssignedTo字段时显示异常。

static void Main(string[] args)
{
    string _uri = "https://dev.azure.com/xyz";
     string _personalAccessToken = 
     "xpdrix7nyspotj3l4gotvvk4cpp2z6l65g5r";
     string _project = "FirstProject";
     Uri uri = new Uri(_uri);
     string personalAccessToken = _personalAccessToken;
     string project = _project;

     VssBasicCredential credentials = new VssBasicCredential("", 
     _personalAccessToken);

     //create a wiql object and build our query
     Wiql wiql = new Wiql()
     {
         Query = "Select *" +
                 "From WorkItems " +
                 "Where [System.TeamProject] = '" + project + "' " +
                  "Order By [State] Asc, [Changed Date] Desc"
     };

     //create instance of work item tracking http client
      sing (WorkItemTrackingHttpClient workItemTrackingHttpClient = 
      new WorkItemTrackingHttpClient(uri, credentials))
      {
         //execute the query to get the list of work items in the results 
         WorkItemQueryResult workItemQueryResult = 
         workItemTrackingHttpClient.QueryByWiqlAsync(wiql).Result;

         //some error handling                
         if (workItemQueryResult.WorkItems.Count() != 0)
         {
             //need to get the list of our work item id's and put them 
             //into an array
             List<int> list = new List<int>();
             foreach (var item in workItemQueryResult.WorkItems)
             {
                 list.Add(item.Id);
             }
             int[] arr = list.ToArray();

             //build a list of the fields we want to see
             string[] fields = new string[3];
             fields[0] = "System.Id";
             fields[1] = "System.Title";
             fields[2] = "System.AssignedTo";
             WorkItemExpand workItemExpand = WorkItemExpand.All;

             //get work items for the id's found in query
             var workItems = 
             workItemTrackingHttpClient.GetWorkItemsAsync(arr, fields=null, workItemQueryResult.AsOf,workItemExpand).Result;

             Console.WriteLine("Query Results: {0} items found", workItems.Count);

             //loop though work items and write to console
             foreach (var workItem in workItems)
             {
                 Console.WriteLine("{0}{1}{2}", workItem.Id, workItem.Fields["System.Title"], workItem.Fields["System.AssignedTo"]);
             }

          }
       }
    }
}

错误是：

System.Collections.Generic.KeyNotFoundException HResult=0x80131577 Message=The给定的密钥在字典中不存在。System.Collections.Generic.Dictionary`2.get_Item(TKey C:\Users\Naresh\source\repos\ScrumBoard\ScrumBoard\Program.cs:line 84中ScrumBoard.Program.Main(String[] args)的Source=mscorlib StackTrace: at Source=mscorlib key)

Answer 1

如果未分配System.Collections.Generic.KeyNotFoundException字段，assigned to异常将被抛出。

请检查是否在所查询的工作项中分配了assigned to字段。

您的代码是可以的，除了我不能编译workItemQueryResult.WorkItems.Count()之外，我将其转换为IList<>。((IList<WorkItemReference>)workItemQueryResult.WorkItems).Count()

​

​

Answer 2

这是因为当您获得工作项时，您指定了fields = null。

您只需要在没有任何附加参数的情况下给出id：

var workItems = workItemTrackingHttpClient.GetWorkItemsAsync(arr).Result;

现在，您将得到包括System.AssignedTo在内的所有字段。

Answer 3

这是新的代码：

static void Main(string[] arg
 {
       
        string _uri = "https://dev.azure.com/xyz";
        string _personalAccessToken = 
       "xpdrix7nyspotj3l4gotvvk4cpp2z6l65g5rd4pfbrl7nskq";
        string _project = "FirstProject";

        /// <summary>
        /// Execute a WIQL query to reutnr a list of bugs using the .NET client library
        /// </summary>
        /// <returns>List of Microsoft.TeamFoundation.WorkItemTracking.WebApi.Models.WorkItem</returns>

        Uri uri = new Uri(_uri);
        string personalAccessToken = _personalAccessToken;
        string project = _project;

        VssBasicCredential credentials = new VssBasicCredential("", _personalAccessToken);

        //create a wiql object and build our query
        Wiql wiql = new Wiql()
        {
            Query = "Select *" +
                    "From WorkItems " +
                    
                    "Where [System.TeamProject] = '" + project + "' " +
                   
                    "Order By [State] Asc, [Changed Date] Desc"
        };

        //create instance of work item tracking http client
        using (WorkItemTrackingHttpClient workItemTrackingHttpClient = new WorkItemTrackingHttpClient(uri, credentials))
        {
            //execute the query to get the list of work items in teh results
            WorkItemQueryResult workItemQueryResult = workItemTrackingHttpClient.QueryByWiqlAsync(wiql).Result;

            //some error handling                
            if (workItemQueryResult.WorkItems.Count() != 0)
            {
                //need to get the list of our work item id's and put them into an array
                List<int> list = new List<int>();
                foreach (var item in workItemQueryResult.WorkItems)
                {
                    list.Add(item.Id);
                }
                int[] arr = list.ToArray();

            
                
                

                //get work items for the id's found in query
                var workItems = workItemTrackingHttpClient.GetWorkItemsAsync(arr).Result;

                Console.WriteLine("Query Results: {0} items found", workItems.Count);

                //loop though work items and write to console
                foreach (var workItem in workItems)
                {
                    Console.WriteLine("{0}          {1}                     {2}", workItem.Id, workItem.Fields["System.Title"], workItem.Fields["System.AssignedTo"]);
                }


            }
        }
        Console.ReadLine();
    }