About managed queries

Azure Boards | Azure DevOps Server 2019 | TFS 2018 | TFS 2017 | TFS 2015 | TFS 2013

A query lists a filtered set of work items. You can initiate a query using the query editor. Optionally, you can perform an ad hoc search using the search box.

With queries, you can perform these functions:

  • List items to perform bulk updates, assign or reassign
  • Review work that's in progress or recently closed
  • Triage work (set priority, review, update)
  • Create a chart and add it to a dashboard
  • Create a chart to get a count of items or sum a field
  • Create a chart that shows a burndown or burnup over time
  • View a tree of parent-child related work items

For the mechanics of constructing and saving queries, see Use the query editor to list and manage queries. For specific examples, click one of the following links.

Getting started

If you are looking for a specific work item, use the ad hoc search box. If you want to generate a list of work items to triage, update, chart, or share with others, then use a managed query.

For a quick reference to query editor tasks and sample queries, see Query quick reference.

Additional tips for working with queries

  • To find work items that are assigned to you, add @Me as the value for the Assigned To field in one of the query clauses.
  • All valid users with standard access can create queries and folders under the My Queries area. To create queries and query folders under Shared Queries, you must have the Contribute permission set. For more information, see Set permissions on queries.
  • You can modify any query by adding criteria to focus on a product area, an iteration, or another field. To modify a query, open the query editor.
  • You can open any query in Excel or Project, where you can update the fields of one or more work items and publish your changes to the database for tracking work items.
  • You can visualize status or progress by creating a pie-chart, column chart, or trend chart for flat-list queries.

For additional tips when working with the new queries experience or the directory-focused queries views, see Tips for working with the directory-focused Queries pages.

My Queries, Shared Queries, and Favorites

Only you can view and run queries that you save under My Queries with the queries directory. Also, you can favorite one of these queries to have it appear within your query selector.

Queries you and others save under Shared Queries can be viewed by everyone with access to the project. Shared queries can be organized within folders and favorited by you or for a team. Also, you can set permissions on the folders and queries to prevent others from moving or editing them.

For details, see:

Example queries

You can list work items based on the following criteria...

Identity based queries

Keywords or phrases

Work item count and numeric field queries

History and revision change queries

Date and iteration based queries

State, reason, or workflow changes

Tag based queries

Build and test field queries

To add a custom field to support your query needs, see Customize your work tracking experience.

To learn about query charts and widgets, see these topics:

Query within or across projects

By default, you query within a single project. However, using the query editor, you can query across projects.

You can view related work items and object within a work item form by installing the Work item visualization extension available from the Visual Studio Marketplace, Azure DevOps tab.