WIQL Query Builder

Build Azure DevOps WIQL queries visually. Pick fields, add conditions, sort results, and copy the finished query in one click.

Templates:

SELECT Fields

FROM

WHERE Clauses

ORDER BY

Generated WIQL

Basic Structure

SELECT [System.Id], [System.Title]
FROM WorkItems
WHERE [System.State] = 'Active'
ORDER BY [System.CreatedDate] DESC

Operators

= <> < > <= >= for comparisons. Contains and Not Contains for partial text matching. In for multiple values. Under for tree paths (Area/Iteration).

Special Values

@Me = current user. @Today = today's date. @Today - 7 = 7 days ago. @CurrentIteration = active sprint.

Grouping

WHERE (
  [System.State] = 'Active'
  OR [System.State] = 'New'
)
AND [System.AssignedTo] = @Me

Work Item Links

Use FROM WorkItemLinks with [Source] and [Target] prefixed fields to query parent/child, related, or custom link types.

Like this tool? Renly does this and more for enterprise teams.

Query your Azure DevOps backlog with plain English. No WIQL memorization needed. Renly writes the queries, runs them, and summarizes the results.

Get started free