TFS Work Items: Queries more than one state

How can I create a query and filter on more than one state? I had this question last week at a client location. If you are interested in a short answer then the answer is to comma separate the states and you use the In operator. For step by step instructions, read the rest of the article.

In Web Access,

Click on the Work tab

Click on Queries

Click on New

Click on New query

In this example, I want to select all bugs that are Approved and Committed

From the Work Item Type Value field, select Bug

Select In in the State’s Operator field and Approved,Committed in the Value field.

You can click the play button to test your query

Save your query