query-index-quick-ref.md

title	titleSuffix	description	ms.custom	ms.technology	ms.assetid	ms.topic	ms.author	author	monikerRange	ms.date
Look up definitions and sample queries	Azure Boards	Index to query operators, macros, and sample queries used to list work items for Azure Boards, Azure DevOps, & Team Foundation Server	boards-queries	devops-agile		reference	kaelli	KathrynEE	>= tfs-2013	10/02/2019

Query quick reference

[!INCLUDE temp]

Use this index to quickly access information on query editor tasks, operators available based on data type, and access sample queries.

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 Query samples for select fields.

Query tasks

Add a query Add a query chart Add a query to a dashboard Add a query folder Add columns to query results Bulk modify query items Define a clause Delete a query Direct-links query Edit a query

Email a query Export a query Favorite a query Filter a query Flat-list query Group a clause Open a query Query across projects Rename a query Run a query

Save a query Set query permissions Tree query Triage query items View a query Understand link types Ungroup a clause Work Item Query Language (WIQL)

Operators and macros supported for each data type

The following table indicates the operators and macros available for the different field data types. Each field is associated with a data type. You can find the data type listed in the descriptions of each field, which you can look up using the Work item field index. Operators available for defining a query clause depends on the data type of the field that you select. For more detailed descriptions of data types, operators, and macros, see Query fields, operators, and macros.

Data type	Description	Supported operators and macros
Boolean 1	Supports a True/False value. Query samples: Query by assignment or workflow changes.	= , <> , =[Field] , <>[Field]
DateTime	A date field in which you can specify a variable, such as or , or a value, such as 1/1/2012. Enter dates in the Date Pattern you set for your personal profile. (See Set personal preferences for details.) For query examples, see Query by date or@CurrentIteration.	= , <> , > , < , >= , <= , =[Field], <>[Field], >[Field], <[Field], >=[Field], <=[Field], In, Not In, Was Ever Macros: , valid with any DateTime field Additional macros supported on Azure DevOps 2019 Update 1 and later versions:: , , , and , valid with any DateTime field
Double	Also referred to as Decimal and includes picklistDouble2. A real number, such as 0.2 or 3.5. Query samples: Query by numeric fields.	= , <> , > , < , >= , <= , =[Field], <>[Field], >[Field], <[Field], >=[Field], <=[Field], In, Not In, Was Ever
GUID	A character string that represents a unique ID.	= , <> , > , < , >= , <= , =[Field], <>[Field], >[Field], <[Field], >=[Field], <=[Field], In, Not In, Was Ever
History	Custom formatted field used to track historical information and only assigned to the History field. Query samples: History and auditing.	Contains Words, Does Not Contain Words
HTML	Text strings that support formatted descriptions, such as the Description or Repro Steps fields. These fields are automatically indexed for full-text search when full-text search is available. Query samples: Query by titles, IDs, and rich-text fields.	Contains Words, Does Not Contain Words, Is Empty3, Is Not Empty3
Identity	A String field that is used to hold a user identity. Query samples: Query by assignment or workflow changes.	= , <> , > , < , >= , <= , =[Field], <>[Field], >[Field], <[Field], >=[Field], <=[Field], Contains, Does Not Contain, In, Not In, In Group, Not In Group, Was Ever Macros: valid for all Identity fields
Integer	Also includes picklistInteger2. A 32-bit integer that is signed, such as 0, 1, 2, 34. Query samples: Query by numeric fields	= , <> , > , < , >= , <= , =[Field], <>[Field], >[Field], <[Field], >=[Field], <=[Field], In, Not In, Was Ever Macros: 4, 5, 5, 6, valid when used with the ID field
PlainText	Multi-line text strings that support long descriptions and are automatically indexed for full-text search, when full-text search is available. Query samples: Query by titles, IDs, and rich-text fields.	Contains Words, Does Not Contain Words, Is Empty3, Is Not Empty3
String	Also includes picklistString2. Short single-line text that can contain up to 255 Unicode characters. String fields support the Title field, picklists (drop-down menus), user account ids, Tags, and other fields. Query samples: Query by titles, IDs, and rich-text fields and Query by picklist value.	= , <> , > , < , >= , <= , =[Field], <>[Field], >[Field], <[Field], >=[Field], <=[Field], Contains, Does Not Contain, In, Not In, In Group, Not In Group, Was Ever Macros: [Any], valid with the Work Item Type field 7, valid with the Team Project field
TreePath	Field type that supports the Area Path and Iteration Path fields. You define the tree structure for a project—area paths and iteration paths. Query samples: Query by area or iteration path and Query by date or current iteration.	Under, Not Under Macros: 8, valid with Area Path field 9 and +/- n10 valid with the Iteration Path field

Notes:

1. The Boolean data type field is supported for TFS 2017 and later versions.
2. The picklist... data types are only assigned to custom fields defined for an inherited process. The Inherited process model is only supported for Azure DevOps Services and Azure DevOps Server 2019.
3. The Is Empty and Is Not Empty operators are supported for Azure DevOps Server 2019 RC2 and later versions.
4. The @Follows macro is supported for TFS 2017 and later versions.
5. The @MyRecentActivity, @RecentMentions, @RecentProjectActivity macros are supported for Azure Boards and TFS 2018.2 and later versions.
6. The @RecentProjectActivity macro is supported for Azure Boards only at this time.
7. The @Project macro is supported for TFS 2015.1 and later versions. The system automatically defaults to filtering based on the current project. To learn more, see Query across projects.
8. The @TeamAreas macro is supported for Azure Boards and Azure DevOps Server 2019 and later versions.
9. The @CurrentIteration macro is supported for TFS 2015 and later versions, and only when run from the web portal.
10. The @CurrentIteration +/- n macro is supported for Azure Boards and Azure DevOps Server 2019 and later versions, and only when run from the web portal.

Query samples for select fields

The following table lists common query fields and their data type for which sample queries are provided. To determine the data type of a field, see Work item fields and attributes, List field attributes.

A Acceptance Criteria (HTML) Activated By (Identity) Activated Date (DateTime) Activity (String) Area Path (TreePath) Assigned To (Identity) Attached File Count (Integer) Automated Test Name (String) Automated Test Type (String) B Blocked (String) Board Column (String) Board Column Done (Boolean) Board Lane (String) Business Value (String) C Changed By (Identity) Changed Date (DateTime) Closed By (Identity) Closed Date (DateTime) Comment Count1 (Integer) Committed (String) Completed Work (Decimal) Created By (Identity) Created Date (DateTime)

D-E-F Discipline (String) Description (HTML) Due Date (DateTime) Effort (Decimal) External Link Count (Integer) Finish Date (DateTime) Found In Build (String) H-P History (History) Hyperlink Count (Integer) ID (Integer) Integrated in Build (String) Iteration Path (TreePath) Link Comment (Integer) Node Name (String) Original Estimate (Decimal) Parameters (HTML) Priority (Integer) R Reason (String) Related Link Count (Integer) Remaining Work (Decimal) Repro Steps (HTML) Resolved By (Identity) Resolved Date (DateTime) Resolved Reason (String) Rev (Integer) Revised Date (DateTime)

S Severity (String) Size (Decimal) Stack Rank (Decimal) Start Date (DateTime) State (String) State Change Date (DateTime) Steps (HTML) Steps to Reproduce (HTML) Story Points (Decimal) System Info (HTML) T Tags (String) Target Date (DateTime) Task Type (String) Team Project (String) Test Suite Type (String) Title (System) Triage (String) V-W Value Area (String) Work Item Type (String)

Notes:

1. The Comment Count field is supported for TFS 2017 and later versions.

Related articles

• Query by field value comparisons
• Guidance to create high-performing queries
• Use categories to group work item types
• Define a managed query
• Work item field index