How to get all valid fields for WIQL query using TFS API C#?

Question

I found this:

But I think that may be in regards to the database copy or something?

I just need to know if there is a way I can get a list of all the valid fields that can go into a SELECT clause in a WIQL like :

SELECT [System.Id],[System.WorkItemType] FROM WorkItem

I don't think WorkItemType is valid, when I tried outputting out it threw an exception:

Console.WriteLine("ID: {0}", workItem.Id);
Console.WriteLine("Work Item Type: {0}", workItem.WorkItemType);

Which version of TFS are you using? – Cece Dong - MSFT Dec 02 '15 at 12:19 — Cece Dong - MSFT, Dec 02 '15 at 12:19
2015 I believe, It's VSO, is it the same? – Sewder Dec 02 '15 at 19:35 — Sewder, Dec 02 '15 at 19:35

score 1 · Accepted Answer · answered Dec 02 '15 at 12:27

You can list all fields defined for a team project collection using the witadmin listfields command:

witadmin listfields /collection:http://ｘｘｘｘ:8080/tfs/DefaultCollection

Or you can install TFS Power Tool to check all fields in "Work Item Field Explorer".

1 Answers1