About managed queries
Azure Boards | Azure DevOps Server 2020 | Azure DevOps Server 2019 | TFS 2018 - TFS 2013
List bugs, user stories, or other work items based on field criteria you specify using queries. You can then review these lists with your team, triage work, or perform bulk work item updates.
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. If you find that your queries take too long to return results, review the Guidance to create high-performing queries.
For specific examples, choose one of the following articles listed under Example queries.
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:
- Organize queries, add a query folder
- Set query permissions
- Favorite a query and Set personal or team favorites
To view the WIQL syntax for a query, and how parenthesis are used to group clauses, install the Marketplace Wiql Editor. This extension supports viewing the WIQL syntax and exporting it to a WIQL file for use in REST API calls. To learn more, see Syntax for the Work Item Query Language (WIQL).
You can list work items based on the following criteria...
Identity based queries
- Active items assigned to me
- Closed items that were assigned to me
- Active items assigned to my team
- Items I've modified in the last 30 days
- Items I closed
- Items I resolved in the last week
- Team or group membership queries
Keywords or phrases
- Keyword or phrase queries
- Undefined field value queries
- Empty or not empty HTML field queries
- Category based queries
Work item count and numeric field queries
- Count of active bugs per developer
- Count of bugs by area and states
- Sum of story points and their status
- Burnup chart of user stories for a sprint
- Sum of remaining work per developer
History and revision change queries
- History contains a specific word
- History doesn't contain a specific word
- Reactivated items
- Items closed within a time period
- Items you've been associated with
Date and iteration based queries
- Items created in the last 30 days
- Items modified on a specific date
- Items resolved today
- Items closed within a specific time period
- Items whose updated status
- Items closed in the current sprint
State, reason, or workflow changes
- Resolved user stories
- Items I resolved in the last week
- Items failing acceptance tests
- Items closed within the last 15 days
- Items removed as they're duplicate
- Items closed and then reactivated
- Stories in the Code/Doing column
- Items in the Expedite swimlane
- Items in a swimlane containing "Test"
Link and attachment count queries
- All child items of a single epic
- All related items
- Items with one or more attachments
- Items with 2 or more hyperlinks
- Items containing external links
Tag based queries
- Items containing a specific tag
- Items that don't contain a specific tag
- Items that contain two or more tags
Build and test field queries
- List bugs and linked test cases
- List automated test cases
- List requirement-based test suites
- List query-based test suites
Team focus queries
- Query quick reference
- Work item field index
- Query permissions
- Wiql Editor (Marketplace extension)
- Enhanced Export (Marketplace extension)
Add a custom field to support your queries
To add a custom field to support your query needs, see Customize your work tracking experience.
About query charts and widgets
To learn about query charts and widgets, see these articles:
Query within or across projects
By default, you query within a single project. However, using the query editor, you can query across projects.
Visualize related work and other objects
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.