Search code examples
tfstfs-workitemwiql

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.

Solution

  • 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: