Create managed queries to list, update, or chart work items

Last Update: 4/4/2017

Team Services | TFS 2017 | TFS 2015 | TFS 2013

A query lists a filtered set of work items. You can initiate a query using the work item search box or through the query editor. By default, you query within a single team project. However, using the query editor, you can query across team projects.

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, using the adhoc query or search box query may be your best bet. If you want to generate a list of work items to triage, update, chart, or share with others, then use a managed query.

Example queries

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

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

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.