| title | titleSuffix | description | ms.custom | ms.technology | ms.assetid | ms.topic | ms.author | author | monikerRange | ms.date |
|---|---|---|---|---|---|---|---|---|---|---|
List work items with managed queries |
Azure Boards |
Track work by creating queries to list work items in Azure Boards, Azure DevOps, & Team Foundation Server |
boards-queries |
devops-agile |
285a014e-89bf-4e5f-bebf-11094e93d796 |
overview |
kaelli |
KathrynEE |
>= tfs-2013 |
09/26/2019 |
[!INCLUDE temp]
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.
If you're just getting started, read View, run, or email a work item query. For a quick reference to query editor tasks and sample queries, see Query quick reference.
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. 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.
- 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.
::: moniker range="azure-devops" 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. ::: moniker-end
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
[!INCLUDE temp]
You can list work items based on the following criteria...
- 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
- Keyword or phrase queries
- Undefined field value queries
- Empty or not empty HTML field queries
- Category based 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 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
- 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
- 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"
- 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
- Items containing a specific tag
- Items that don't contain a specific tag
- Items that contain two or more tags
- List bugs and linked test cases
- List automated test cases
- List requirement-based test suites
- List query-based test suites
::: moniker range=">= azure-devops-2019"
- Assigned to a member of a team
- Assigned to a team's area path
- Assigned to a team's current sprint
- Assigned to a team's sprint window
::: moniker-end
::: moniker range=">= tfs-2013 <= tfs-2018"
::: moniker-end
- Query quick reference
- Work item field index
- Query permissions
- Wiql Editor (Marketplace extension)
- Enhanced Export (Marketplace extension)
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 articles:
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.