Work Item Query Language (WIQL)

Eintrag zuletzt aktualisiert am: 30.10.2018

SQL-ähnliche Abfragesprache für Work Items in Azure DevOps
https://docs.microsoft.com/en-us/azure/devops/boards/queries/wiql-syntax?view=vsts

"A query defined using the Work Item Query Language (WIQL) 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."

Beispiel

SELECT System.ID, System.Title from workitems
where Priority=1 order by System.ID asc