Work Item Query Language (Work Item Query Reference)
Article
A Work Item Query Language (WIQL) query consists of a SELECT statement that lists the fields to be returned as columns in the result set. You can further qualify the result set by using a logical expression. You can specify a sort order. Use an ASOF clause to state that a query is evaluated as of a previous time.
Queries are not case sensitive.
Typical Query
The following typical WIQL query example uses reference names for the fields. The query selects work items where the Priority field equals 1. The query returns the ID and Title of the return set as columns. The results are sorted by ID in ascending order.
SELECT System.ID, System.Title from workitems
where Priority=1 order by System.ID asc
Examples
A query consists of a SELECT statement and a qualifying WHERE clause. The following shows the basic syntax.
SELECT
SELECT Select_List
FROM workitems
[WHERE Conditions]
[ORDER BY Column_List]
[ASOF DateTimeConditions]
The following example statements show specific qualifying clauses.
AND
SELECT [System.Id], [System.Title]
FROM WorkItems
WHERE [System.TeamProject] = @project
AND [System.AssignedTo] = 'Judy Lew'
OR
SELECT [System.Id], [System.Title]
FROM WorkItems
WHERE [System.TeamProject] = @project
AND ( [System.AssignedTo] = 'Mark Steele'
OR [System.AssignedTo] = 'Merav Sror' )
NOT
SELECT [System.Id], [System.Title]
FROM WorkItems
WHERE [System.TeamProject] = @project
AND [System.AssignedTo] EVER 'Anne Wallace'
AND [System.AssignedTo] NOT CONTAINS 'Danny Levin'
EVER
SELECT [System.Id], [System.Title]
FROM WorkItems
WHERE [System.TeamProject] = @project
AND [System.AssignedTo] EVER 'Anne Wallace'
UNDER
SELECT [System.Id], [System.Title]
FROM WorkItems
WHERE [System.TeamProject] = @project
AND [System.AssignedTo] EVER 'David Galvin'
AND [System.AreaPath] UNDER 'Agile1\Area 0'
Sort
SELECT [System.Id], [System.Title]
FROM WorkItems
WHERE [System.TeamProject] = @project
AND [System.AssignedTo] = 'Jon Ganio'
ORDER BY [System.Id] [asc | desc]
ASOF
SELECT [System.Title]
FROM workitems
WHERE [System.IterationPath] = 'MyProject\Beta'
AND [System.AssignedTo] = 'Jim Daly'
ASOF '3/16/06 12:30'