Query by titles, IDs, and rich-text fields
VSTS | TFS 2018 | TFS 2017 | TFS 2015 | TFS 2013
When you want to find work items based on a keyword or phrase, you can do so by entering the keyword or phrase within the search box. This initiates a new query which you can modify as needed to further refine your filter criteria, as described in this topic.
If your admin has installed the Work item search extension, the search box will perform an adhoc query using the extension. You'll no longer be able to initiate a managed search. Instead, you'll need to open the Work>Queries page and construct a query. To learn more, see Adhoc vs managed work item queries.
List items based on keywords or phrases
Use Contains and Contains Words to list items that partially or exactly match the words or phrase that you enter.
Choose Contains or Does Not Contain to search against exact or partial matches of a word or phrase. Choose Contains Words or Does Not Contain Words to search against an exact phrase or to use the wildcard character, *. These operators use the full-text search index.
List items based on undefined field values
You can find work items that have an undefined field value by using the equals operator (=) and leaving the Value for the field blank. For example, the following filters will list all work items of type Task whose Activity field is blank.
To list work items based on a field that isn't blank, use the not operator (<>) and leave the Value blank.
List items based on categories
To filter work items based on the category they belong to, use the In Group operator. For example, the following filter criteria will return all work items that are in the current team project, assigned to the team member, and defined as belonging to the Bug Category.
What items appear in the Requirement or Task categories?
The default assignments of work item types to each category are listed below for each process.
|Process||Requirement category||Task category|
|Scrum||Product Backlog Item||Task|
However, each team can determine if the Bug work item type appears in either the Requirement or Task category. See Show bugs on backlogs and boards.
Also, you can add custom work item types to a backlog. For details, see Add or modify a work item type, Add a custom WIT to a backlog or board .
Common fields for most work item types
The following table describes common fields used to filter queries. The ID fields uniquely identify work items in a list. Use the Title field to distinguish the work item from all others of the same type. The Description and other rich-text (data type=HTML) fields provide additional information that is needed to implement work and track changes. After a work item is created, you can modify all fields except for the ID. When you add and save a work item, the ID is assigned by the system and cannot be changed.
Note: The system automatically indexes all long-text fields with a data type of PlainText and HTML fields for full-text search. This includes the Title, Description, and Steps to Repro fields. For more information and server and collation requirements applicable to on-premises TFS, see Query fields, operators, values, and variables - Full-text and partial word searches.
|Field name||Description||Work item type|
Acceptance Criteria 1
A description of the criteria to be met before the bug or product backlog item can be closed.
Before work begins on a bug or product backlog item, the criteria for customer acceptance should be described as clearly as possible. Conversations between the team and customers to define the acceptance criteria will help ensure that your team understands your customers' expectations. The acceptance criteria can be used as the basis for acceptance tests so that you can more effectively evaluate whether an item has been satisfactorily completed.
Reference name=Microsoft.VSTS.Common.AcceptanceCriteria, Data type=HTML
Bug, Epic, Feature, Product backlog item (Scrum)
|Description 1, 2||
Use this field to provide indepth information about a work item.
Reference name=System.Description, Data type=HTML
The unique identifier that is assigned to a work item. Work item IDs are unique across all team projects and within a team project collection.
Reference name=System.Id, Data type=Integer
|Repro Steps (or Steps to reproduce) 1||
The steps that are required to reproduce unexpected behavior. Capture enough information so that other team members can understand the full impact of the problem as well as whether they have fixed the bug. This includes actions taken to find or reproduce the bug and expected behavior.
Reference name=Microsoft.VSTS.TCM.ReproSteps, Data type=HTML
Describes how an impediment was resolved.
Reference name=Microsoft.VSTS.Common.Resolution, Data type=HTML
Information about the software and system configuration that is relevant to the bug, code review, or feedback.
Reference name=Microsoft.VSTS.TCM.SystemInfo, Data type=HTML
|Bug, Code Review Request, Feedback Request
The team project to which a work item belongs. Add this field to a query when you want to filter your list to items in one or more team projects.
Note: For VSTS or for TFS 2015.1 and later versions, you must check the Query across projects option in the query editor for this field to appear in the drop down field list. To learn more, see Example queries, query across team projects.
Reference name=System.TeamProject, Data type=String
A short description that summarizes what the work item is and helps team members distinguish it from other work items in a list.
Reference name=System.Title, Data type=String
|Work Item Type||
The name of the work item type. Work item types are defined based on the process used when you created your team project. For an overview, see Choose process. To learn how to add a custom work item type, see Add or modify a work item type.
To filter work items based on their category assignment, you can use the In Group and Not In Group operators and select a category from the drop-down list.
Reference name=System.WorkItemType, Data type=String
- To learn more about working with rich-text fields, see Share plans.
- Upon upgrade to Team Foundation Server 2012, the Description field was changed from a field type of PlainText to HTML. Using the witadmin changefield command you can revert the data type for this field. See Manage work item fields (witadmin).
REST API and SDK resources
To programmatically interact with queries, see one of these REST API resources:
Or, for TFS 2015 and earlier versions, Query for Bugs, Tasks, and Other Work Items.
Feedback and support
We welcome your feedback.
Follow us on Twitter @vsts.