-
Notifications
You must be signed in to change notification settings - Fork 2.5k
/
Copy pathquery-faqs.yml
204 lines (168 loc) · 12.4 KB
/
query-faqs.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
### YamlMime:FAQ
metadata:
title: Frequently Asked Questions (FAQs) about Queries in Azure Boards and Azure DevOps
description: Get answers to common questions about working with work item queries in Azure DevOps.
titleSuffix: Azure Boards
ms.custom: boards-queries
ms.service: azure-devops-boards
ms.author: chcomley
author: chcomley
ms.topic: faq
monikerRange: '<= azure-devops'
ms.date: 04/01/2022
title: FAQs about queries in Azure Boards and Azure DevOps
summary: |
[!INCLUDE [version-lt-eq-azure-devops](../../includes/version-lt-eq-azure-devops.md)]
The Query Editor supports finding work items by specifying query clauses based on fields, operators, and values. You can save and share these queries with others in your team. Here are some answers to frequently asked questions about work item queries.
sections:
- name: General
questions:
- question: Can I use a wildcard in my query?
answer: |
Yes. The wildcard character is an asterisk (*). For samples, see [Query by titles, IDs, and rich-text fields](titles-ids-descriptions.md#keyword-or-phrase-query-with-wildcards).
- question: What's the difference between a query and a semantic search?
answer: |
While both query and semantic searches find and list work items, the filter features and results presentation are different. For more information, see [Functional work item search, Semantic search vs. managed work item queries](../../project/search/functional-work-item-search.md).
- question: Can I export a query and import to another project?
answer: |
**Yes**. You can save a query as a `.wiq` file, update the syntax, and then import it to another project, organization, or collection.
- question: What are all the query filter functions?
answer: |
From the Query Editor, you can exercise the following filter functions. Choose the filter to jump to an article with sample queries. In addition to the query filters, you can [interactively apply filters to query results](../backlogs/filter-backlogs-boards-plans.md).
::: moniker range="<=azure-devops"
> [!NOTE]
> Managed queries don't support proximity searches, however semantic searches do. In addition, semantic searches support both `*` and `?` as wildcard characters and you can use more than one wildcard character to match more than one character. For more information, see [Advanced work items search](../../project/search/advanced-work-item-search-syntax.md).
::: moniker-end
---
:::row:::
:::column span="2":::
**Filter features**
:::column-end:::
:::column span="2":::
**Macros**
:::column-end:::
:::row-end:::
---
:::row:::
:::column span="1":::
::: moniker range="<=azure-devops"
- [Compare fields](./query-field-value.md)
- [Key words](./titles-ids-descriptions.md)
- [Linked work items](./linking-attachments.md)
- [Logical groupings](./using-queries.md)
- [Query macros](about-managed-queries.md#supported-macros)
- [Tags](./add-tags-to-work-items.md#query)
- [Was Ever](./query-by-workflow-changes.md)
- [Wildcard](./titles-ids-descriptions.md)
::: moniker-end
:::column-end:::
:::column span="1":::
::: moniker range="<=azure-devops"
- [Blank or empty fields](./titles-ids-descriptions.md#empty-or-not-empty-html-field-queries)
- [Boolean searches](./query-by-workflow-changes.md#query-changes-to-a-kanban-board)
- [History and Discussion](./history-and-auditing.md)
- [Board fields](./query-by-workflow-changes.md#query-changes-to-a-kanban-board)
- [In and Not In Group searches](./planning-ranking-priorities.md)
- [Search across projects](./using-queries.md)
::: moniker-end
:::column-end:::
:::column span="2":::
::: moniker range="<=azure-devops"
- [[Any]](titles-ids-descriptions.md)
- [@Me](query-by-workflow-changes.md)
- [@Today](query-by-date-or-current-iteration.md)
- [@CurrentIteration, @CurrentIteration +/-n](query-by-date-or-current-iteration.md)
- [@Follows](titles-ids-descriptions.md#following)
- [@MyRecentActivity, @RecentMentions, @RecentProjectActivity](titles-ids-descriptions.md#recent-macros)
- [@StartOfDay, @StartOfMonth, @StartOfWeek, @StartOfYear](query-by-date-or-current-iteration.md)
- [@TeamAreas](query-by-area-iteration-path.md)
::: moniker-end
:::column-end:::
:::row-end:::
---
- question: Can I filter the Query Results?
answer: |
**Yes**. See [Interactively filter backlogs, boards, queries, and plans](../backlogs/filter-backlogs-boards-plans.md).
- question: Can I run several queries at the same time?
answer: |
**Yes**. Open a query in a new browser tab to run several queries at the same time.
- question: What query macros are only supported from the web portal?
answer: |
The following macros are only supported from the web portal: **@CurrentIteration**, **@CurrentIteration +/- n**, **@Follows**, **@MyRecentActivity**, **@RecentMentions**, **@RecentProjectActivity**, **@TeamAreas**. Queries that contain these macros won't work when opened in Visual Studio/Team Explorer, Microsoft Excel, or Microsoft Project.
- name: Navigate
questions:
- question: How do I quickly navigate to queries I view frequently?
answer: |
- Favorite those queries and other artifacts that you view frequently. Choose the :::image type="icon" source="../../media/icons/icon-favorite-star.png" border="false"::: star icon to favorite a query.
- Favorited queries (:::image type="icon" source="../../media/icons/icon-favorited.png" border="false"::: favorited icon) are listed in the **Queries>Favorites** page. Also, you can select one from the queries selector, as shown in the following image.
> [!div class="mx-imgBorder"]
> 
Or, you can select from any of your favorited items by choosing the :::image type="icon" source="../../media/icons/inbox.png" border="false"::: inbox icon and choose **Favorites**.
- question: How do I quickly navigate to queries within the same query folder?
answer: |
When viewing a query, you can use the queries breadcrumb selector (:::image type="icon" source="../../media/icons/breadcrumb-selector.png" border="false"::: the breadcrumb icon changes to :::image type="icon" source="../../media/icons/context-menu-selector.png" border="false"::: a context menu selector) to view the queries defined within the folder. To open the queries folder, choose the folder name.
> [!div class="mx-imgBorder"]
> 
- name: Find work items
questions:
- question: Where can I find work assigned to me or work that I'm following?
answer: |
Open **Queries>All**. Under the **My Queries** section are two fully customizable queries: **Assigned to me** and **Followed work items**.
- question: Where can I find recent work item activity?
answer: |
- Open **Boards>Work Items** and select the **Recently updated** view. See [View and add work items](../work-items/view-add-work-items.md).
- You can also use the macros — <strong>@Me</strong>, <strong>@Follows</strong>, **MyRecentActivity**, <strong>@RecentMentions</strong>, <strong>@RecentProjectActivity</strong> — to create custom queries. These queries can filter for work items assigned to you, that you're following, and so on. To learn more about these macros, see [Query macros and variables](query-operators-variables.md#macros).
- question: How do I sort on the Parent field?
answer: |
You can't. Sorting a query on the **Parent** field isn't a supported feature.
- name: Linked work item queries
questions:
- question: How do I query for a list of related work items?
answer: |
You can't query for work items that contain links solely based on the **Related** link type. You can query for work items that have links by specifying `Related Link Count > 0`. However, the results contain all work items containing links to other work items, including **Parent-Child**, **Predecessor-Successor**, and other link types.
- question: Can I query for work items linked across projects?
answer: |
**No**. There's a prohibitive performance cost for trying to execute such a query, so it isn't supported.
- question: Can I link work items across organizations or collections?
answer: |
::: moniker range="azure-devops"
**Yes** across organizations. See [Link user stories, issues, bugs, and other work items; Link to a remote work item](../backlogs/add-link.md). However, you can't run a search for work items linked from other projects than the current project you're connected to.
::: moniker-end
::: moniker range="< azure-devops"
**No** across collections. This feature isn't supported.
::: moniker-end
- name: Bulk add and update work items using queries
questions:
- question: Can I export a cross-project query to Excel?
answer: |
::: moniker range="<=azure-devops"
**No**. Cross-project queries won't open in Excel. However, you can export a cross-project query to a .csv file, open it in Excel, and import it to Azure Boards. For more information, see [Bulk import or update work items using CSV files](import-work-items-from-csv.md).
::: moniker-end
- question: How do I manage dependencies across projects?
answer: |
To manage dependencies in Azure Boards, you can link work items using the Predecessor/Successor link type. To learn how, see [Link user stories, issues, bugs, and other work items](../backlogs/add-link.md).
- name: Query folders
questions:
- question: Can I change the owner of a query or folder?
answer: |
**No**. You can only enable permissions for users and groups from the permissions window for the query or folder.
- question: Can I move a query or a folder?
answer: |
**Yes**. In the web portal, choose **Rename** from the context menu. In Team Explorer for Visual Studio, drag the folder to the new location. In Team Explorer Everywhere or Eclipse, choose **Move** from the context menu and select the folder to which you want to move the item.
- question: Can I add folders to My Favorites or Team Favorites?
answer: |
**No**. This feature isn't supported.
- question: Are the queries and folders I create from the web portal the same as in Team Explorer?
answer: |
**Yes**. You may have to refresh your browser or client to see changes you make in another client. For Visual Studio 2019, you must [choose the legacy experience](../work-items/set-work-item-experience-vs.md) to see work item queries and folders.
- name: Monitor progress with queries
questions:
- question: How can I best use queries to monitor progress on a project or team?
answer: |
- [Define a chart for a query](../../report/dashboards/charts.md) and add it to a dashboard, or add the [Query Results widget](../../report/dashboards/widget-catalog.md#query-results-widget) to a dashboard. Each time you open the dashboard, the query automatically runs and refreshes.
additionalContent: |
## Related articles
- [Azure Boards FAQs](../faqs.yml)
- [Work across projects FAQs](../../project/work-across-projects-faqs.yml)
- [Excel FAQs](../backlogs/office/faqs.yml)