TFS WIQL - Searchby keyword using TFS API and C #

Question

Quick syntax question: I can easily return TFS elements using several other suggestions, but I need to search by a specific keyword. Request below:

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

System.Keywords - problem, this part of the sentence is incorrect. But I can not find the correct syntax anywhere. Help me please!

Answer 1

In the future, if you come across a situation where you are not sure about the field name of the work item. You can connect to the TFS database, open the team collective project database and see the field table.

Let's say, for example, [Tfs_DefaultCollection]. [dbo]. [Fields]. This will show you the field name, link name, field ID, etc.