Multiple "Value" queries in TFS 12.0

Question

Is it possible to include multiple values in a TFS query so that I don't have to create separate AND clauses?

Right now I'm having to do the following.

AND > STATE <> CLOSED
AND > STATE <> RESOLVED
AND > STATE <> COMPLETED

I'm just trying to find all tasks that are NOT closed, completed, or resolved. What I have above currently works, but I'm just wondering if I can do this with ONE clause (I was thinking I could separate these by commas (like closed, completed, resolved), but that's not working - when I use commas, it actually seems to ignore everything and show every item).

Answer 1

You can use In to search for any value in a delimited set. Separate values with the list separator that corresponds to the regional settings that are defined for your client computer. For example, you might use a comma(,). More details here:

State   IN    New, Active

But there is no NOT IN equivalent.

You don't need to group the states though (it's one less step)