Cross-service and enhanced query operations
Azure DevOps Services | Azure DevOps Server 2020 | Azure DevOps Server 2019 | TFS 2018
Managed queries are primarily focused on listing and working with work items. However, the query capabilities also support several cross-service operations, some of which require installation of a Marketplace extension.
Query-based dashboard widgets
Along with defining flat-list query charts that you can add to a dashboard, you can configure one of the following query-based widgets.
Other query-based widgets are available from the Azure DevOps Marketplace.
Query filters used in notifications
Notifications support query filter criteria so that you can customize when you'll receive notifications. There may be limitations in what fields can be used to support notification filtering.
To learn more, see Manage your personal notifications
WIQL syntax, Wiql editor, and
Managed queries use the work item query language (WIQL), a language similar to Structured Query Language (SQL). You can gain access to the WIQL syntax behind a managed query when you install the Wiql Editor Marketplace extensions.
This extension adds the following to your Azure Boards web portal:
- Edit query wiql (Work Item Query Language) to the More commands menu on the Query Editor and Query Results pages.
- WIQL Playground page to Boards.
From these interfaces you can exercise the following query features:
- View the underlying WIQL syntax of a managed query
- Run historical queries using the
ASOFoperator won't be saved in a managed query)
- Specify a
MODEclause for linked work items to further refine the query results (
MODEclause won't be saved in a managed query)
- Move, copy, or paste query clauses
- Import and export queries as
.wiqfiles from one project, organization, or collection to another
- Export WIQL for use in REST API calls.
You may find that it's easier to read queries with lots of clauses or heavily nested clauses from the WIQL format. For exceptionally large queries, the load times from a WIQL query may yield better load times.
WIQL has five parts shown in the following syntax snippet. The WIQL syntax is not case-sensitive.
SELECT [State], [Title] FROM WorkItems WHERE [Work Item Type] = 'User Story' ORDER BY [State] Asc, [Changed Date] Desc ASOF '6/15/2010'
To learn more about WIQL, see Syntax for the Work Item Query Language (WIQL).
For queries made against Azure DevOps, the WIQL length must not exceed 32K characters. The system won't allow you to create or run queries that exceed that length.
.wiq file structure
The following syntax shows the structure of the
.wiq file. For details on each
WorkItemQuery syntax element, see Define a work item query to add to a process template
<WorkItemQuery Version="1"> <TeamFoundationServer>collectionURL </TeamFoundationServer> <TeamProject>TeamProjectName </TeamProject> <Wiql> WorkItemQueryLanguage </Wiql> </WorkItemQuery>
Extensions and manage queries
The following Azure DevOps Marketplace extensions work with managed queries to provide more functionality.
Most Marketplace extensions are not supported features of Azure Boards and therefore not supported by the product team. For questions, suggestions, or issues you have when using these extensions, visit their corresponding extension page.
Query Tile PRO: Adds the Query Tile PRO widget to the widget catalog for dashboards. This widget provides support for all query types (not just flat list queries) and provides more options to configure calculated values on the widget.
Wiql to OData: Adds the Translate to OData option to the More commands menu on the Query Editor and Query Results pages. You can then use this query or augment it to retrieve the work items from the Analytics service. To learn more, see Query your work tracking data using OData Analytics.
Open in Power BI: Adds the Open in Power BI option to the More commands menu on the Query Editor and Query Results pages. You can then use Power BI to generate reports based on the Analytics work tracking data. You can add these reports to an Azure DevOps dashboard. To learn more, see Query your work tracking data using OData Analytics.
Enhanced Export: Lets you export work item queries or test plans to document-like formats. To get the output formatted the way you want, you can select different templates to get the form and layout of your choice. You can preview, print or even open the document directly in Office.
To programmatically interact with queries, see one of these REST API resources:
- Azure DevOps Services REST API Reference
- Work item query language
- Work item query language (WIQL) syntax
- Fetch work items with queries programmatically
Submit and view feedback for