Creating a VSTS Extension, using WIQL query to grab work item data, can I grab Activity field data?

Question

I'm creating a Visual Studio Team Services extension that in it's current iteration is supposed to display child tasks for development, testing, etc. that were added to a work item. I build a WIQL query to get these tasks and some data about them.

In VSTS (and TFS), tasks have an Activity field, which I want, to differentiate between the different types of tasks (development, testing, etc.). However, I'm finding with the below WIQL query I create, I get the following error: TF51005: The query references a field that does not exist. The error is caused by «[System.Activity]». Is there a way I can get access to the Activity field for those tasks? Or is it just not supported currently?

SELECT [System.Id], [System.WorkItemType], [System.Title], 
       [System.Activity], [System.State] 
FROM WorkItemLinks 
WHERE (Source.[System.TeamProject] = 'someProjectID' 
    AND Source.[System.Id] = someWorkItemID
    AND Source.[System.State] <> 'Removed') 
    AND ([System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward') 
    AND (Target.[System.WorkItemType] = 'Task') 
MODE(Recursive)

Working through this I discovered https://marketplace.visualstudio.com/items?itemName=ottostreifel.wiql-editor, which has helped make it alot easier debugging my WIQL query. I highly recommend it to anyone who is new to working with WIQL.

starian chen-MSFT starian chen-MSFT · Accepted Answer · 2017-08-02T06:56:39

You can create a query with necessary fields in web access, then get detail wiql by using Get a query or folder REST API (add $expand=wiql parameter).

Creating a VSTS Extension, using WIQL query to grab work item data, can I grab Activity field data?

2 Answers