Retrieve the WIQL of a saved query created in TFS

Question

I have created a query in TFS interactively using the web interface. Now I want to get the WIQL that it is using.

The only way I know how is to call the RESTful api, and pass $expand=wiql. Is there an easier way? Ideally from the interactive web interface?

score 8 · Accepted Answer · edited Mar 10 '22 at 21:29

8

You can use Chrome's "Developer Tools" (under "More Tools") click the Network tab and run the TFS query. You'll see the query item in the list of items. Click on the query item and you'll see the WIQL code in the view pane.

Example:

edited Mar 10 '22 at 21:29

kmote

16,095
11
68
91

answered Jun 26 '20 at 13:50

Funkpotamus

96
1
2

Brilliant! I've been looking for something like this for months! – kmote Mar 10 '22 at 21:29

DaveShaw · Answer 2 · 2016-07-12T20:53:56.967

5

Doesn't seem like you can do it in the Web Access. You can however do it in Visual Studio (if you have it).

Open the Query and then Edit it, now if you do File, Save as... you can then save the query as a .wiq XML file, that will include the WIQL:

Example content:

<?xml version="1.0" encoding="utf-8"?>
<WorkItemQuery Version="1">
    <TeamFoundationServer>https://----.visualstudio.com/defaultcollection</TeamFoundationServer>
    <TeamProject>Test Agile</TeamProject>
    <Wiql>SELECT [System.WorkItemType], [System.Title], [System.State], 
    [Microsoft.VSTS.Scheduling.StoryPoints], [System.IterationPath], [System.Tags] 
    FROM WorkItemLinks 
    WHERE Source.[System.WorkItemType] in group 'Microsoft.RequirementCategory' 
</WorkItemQuery>

edited Jul 12 '16 at 20:53

answered Jul 12 '16 at 20:41

DaveShaw

52,123
16
112
141

Thanks. Not ideal, since many of our team does not have VS installed. But good to know! – John Henckel Jul 13 '16 at 13:37
Team Explorer Everywhere might offer the same functionality if you have eclipse users.. – DaveShaw Jul 13 '16 at 15:40

Retrieve the WIQL of a saved query created in TFS

2 Answers2

Linked