CODEWITHSUNDEEP
tfstfs-workitemwiql
Jim Horn
Jim Horn

Reputation: 889

TFS Query Editor: Is there a way to get the underlying WIQL for a given TFS shared query?

I've been asked to take a bunch of saved TFS Work Items > Shared Queries and reverse engineer them as SSRS reports for more elegant dashboarding.

For all of these I can right-click > Query Editor and it will take me to the Query Editing GUI, which has drop-down list for fields, but I'm not seeing any functionality that allows one to view the underlying WIQL query against the TFS_Warehouse (I'm assuming) database.

Question: Is there a way to get the underlying WIQL for a given TFS Shared Query?

enter image description here I've done some searching on my own, and am finding multiple pages related to writing your own, but none where you can get the pre-existing for a shared query.

Upvotes: 1

Views: 1519

Answers (1)

jessehouwing
jessehouwing

Reputation: 115037

To get the underlying WIQL you can use File-Save as

save-as menu location

Pick "file" as target option:

save as dialog

To create a warehouse query use the new report option in the Team tab in Excel. That will allow you to select a work item query which will be turned into a report.

See:

Upvotes: 2

Related Questions