Wed Feb 15 2006
This past release of TFS brought us the much needed friendly names in the Team Foundation Client user drop down lists. Before that change, your WIQL query may have looked like this:
As you can see we are searching for any Work Item assigned to UserIdA and UserIdB. The user list is delimited by a comma ( this will become important later ). After the release canidate release that same query may now look like the following:
SELECT [System.Id], [System.Title] FROM WorkItems WHERE [System.TeamProject] = @project AND [System.AssignedTo] IN ('UserIdA', ''UserIdB') ORDER BY [System.Id]
The only change to this query was the replacement of the alias with the users First Name Last Name. This query assumes your Active Directory is setup to display First Name Last Name rather than Last Name, First Name. If your Active Directory is setup like the latter then your query will look like: >
... AND [System.AssignedTo] IN ('FirstNameUserA LastNameUserA', 'FirstNameUserB LastNameUserB') ...