Azure DevOps Services | Azure DevOps Server 2022 - Azure DevOps Server 2019
The Query Editor supports finding work items by specifying query clauses based on fields, operators, and values. You can save and share these queries with others in your team. Here are some answers to frequently asked questions about work item queries.
Yes. The wildcard character is an asterisk (*). For samples, see Query by titles, IDs, and rich-text fields.
While both query and semantic searches find and list work items, the filter features and results presentation are different. For more information, see Functional work item search, Semantic search vs. managed work item queries.
Yes. You can save a query as a .wiq file, update the syntax, and then import it to another project, organization, or collection.
From the Query Editor, you can exercise the following filter functions. Choose the filter to jump to an article with sample queries. In addition to the query filters, you can interactively apply filters to query results.
Piezīme
Managed queries don't support proximity searches, however semantic searches do. In addition, semantic searches support both * and ? as wildcard characters and you can use more than one wildcard character to match more than one character. For more information, see Advanced work items search.
Filter features
Macros
Yes. Open a query in a new browser tab to run several queries at the same time.
The following macros are only supported from the web portal: @CurrentIteration, @CurrentIteration +/- n, @Follows, @MyRecentActivity, @RecentMentions, @RecentProjectActivity, @TeamAreas. Queries that contain these macros won't work when opened in Visual Studio/Team Explorer, Microsoft Excel, or Microsoft Project.
- Favorite those queries and other artifacts that you view frequently. Choose the
star icon to favorite a query. - Favorited queries (
favorited icon) are listed in the Queries>Favorites page. Also, you can select one from the queries selector, as shown in the following image.
Or, you can select from any of your favorited items by choosing the 
inbox icon and choose Favorites.
When viewing a query, you can use the queries breadcrumb selector (
the breadcrumb icon changes to 
a context menu selector) to view the queries defined within the folder. To open the queries folder, choose the folder name.
Open Queries>All. Under the My Queries section are two fully customizable queries: Assigned to me and Followed work items.
Open Boards>Work Items and select the Recently updated view. See View and add work items.
You can also use the macros — @Me, @Follows, MyRecentActivity, @RecentMentions, @RecentProjectActivity — to create custom queries. These queries can filter for work items assigned to you, that you're following, and so on. To learn more about these macros, see Query macros and variables.
You can't. Sorting a query on the Parent field isn't a supported feature.
You can't query for work items that contain links solely based on the Related link type. You can query for work items that have links by specifying Related Link Count > 0. However, the results contain all work items containing links to other work items, including Parent-Child, Predecessor-Successor, and other link types.
No. There's a prohibitive performance cost for trying to execute such a query, so it isn't supported.
Yes across organizations. See Link user stories, issues, bugs, and other work items; Link to a remote work item. However, you can't run a search for work items linked from other projects than the current project you're connected to.
No across collections. This feature isn't supported.
No. Cross-project queries won't open in Excel. However, you can export a cross-project query to a .csv file, open it in Excel, and import it to Azure Boards. For more information, see Bulk import or update work items using CSV files.
To manage dependencies in Azure Boards, you can link work items using the Predecessor/Successor link type. To learn how, see Link user stories, issues, bugs, and other work items.
No. You can only enable permissions for users and groups from the permissions window for the query or folder.
Yes. In the web portal, choose Rename from the context menu. In Team Explorer for Visual Studio, drag the folder to the new location. In Team Explorer Everywhere or Eclipse, choose Move from the context menu and select the folder to which you want to move the item.
No. This feature isn't supported.
Yes. You may have to refresh your browser or client to see changes you make in another client. For Visual Studio 2019, you must choose the legacy experience to see work item queries and folders.
- Define a chart for a query and add it to a dashboard, or add the Query Results widget to a dashboard. Each time you open the dashboard, the query automatically runs and refreshes.