TFS WIQL - Searchby keyword using TFS API and C#

Question

Quick syntax question: I can return TFS items just fine using several other clauses, but I need to search by specific keyword. Query below:

WorkItemCollection results = wis.Query("SELECT [System.Id] FROM WorkItems WHERE [System.WorkItemType] = 'Dev Bug' AND [System.Keywords] = 'constellation'");

System.Keywords is the problem, this part of the clause is not correct. But I cannot find the right syntax anywhere. Help please!!

Persistence helps :.). Since it's a custom field I removed "System." from System.Keywords and this works just fine. Hopefully this will help someone else. — mynameisneo, Jan 08 '12 at 22:15
BYW, If that is the solution, you can post it as an answer and accept it. — DaveShaw, Jan 08 '12 at 23:55
I have to wait a few hours apparently, I don't have enough stackoverflow cred :). — mynameisneo, Jan 09 '12 at 00:06

score 3 · Accepted Answer · answered Jan 09 '12 at 22:16

In future, if you run into a situation where you aren't sure about the name of the work item field. You can connect to the TFS database, open the team project collection database and look at the fields table.

Lets say for example [Tfs_DefaultCollection].[dbo].[Fields]. This will show you the field name, reference name, field Id, etc.

TFS WIQL - Searchby keyword using TFS API and C#

1 Answers1