Creating Shared Queries in Azure DevOps

Creating queries in Azure DevOps is a great way to filter and search for specific work items based on a set of criteria. In this tutorial, we’ll walk through the steps to create queries in Azure DevOps.

1. Open the Query Editor: To create a query in Azure DevOps, you need to open the Query Editor. To do this, go to the project where you want to create the query and click on the “Boards” tab. From there, select “Queries” and then click on “New Query.”
2. Choose the Query Type: Once you have opened the Query Editor, you will need to choose the type of query you want to create. There are several types of queries available, including “Flat List,” “Tree of Work Items,” “Direct Links,” and “Test Cases.”
3. Define the Filter Criteria: Next, you need to define the filter criteria for your query. You can filter by various fields such as “Assigned To,” “State,” “Iteration Path,” and “Tags.” You can also define multiple criteria by adding new filter clauses.
4. Choose the Columns to Display: After you have defined the filter criteria, you need to choose the columns that you want to display in the query results. You can choose from a wide variety of columns, including fields such as “Title,” “Work Item Type,” “State,” and “Created Date.”
5. Save the Query: Once you have defined the filter criteria and chosen the columns to display, you can save your query. You can save your query as a new query or update an existing query. You can also choose to share your query with other team members.
6. Run the Query: Finally, you can run your query to see the results. You can sort the results by any column by clicking on the column header. You can also export the query results to Excel or save them as a PDF.

By following these steps, you can create a query in Azure DevOps to return work items based on filter criteria. Queries can help you easily find and manage work items and can be used for a wide range of purposes, such as tracking progress, identifying bugs and issues, and planning sprints.