Work Item Query Language
TFS Work Item Query Language is the syntax used by TFS work item queries
Questions tagged [wiql]
143 questions
13
votes
1 answer
Find WorkItems that were assigned to X in the last 30 days
I'm trying to find all WorkItems that were assigned to a person X in the last 30 days.
The big problem I have is the "in the last 30 days"-part.
I thought about using the "ever" or "asof" keywords, but couldn't find a good answer yet.. something…
Simon Woker
- 4,994
- 1
- 27
- 41
9
votes
2 answers
Specifying a list of items for the parameters with WorkItemStore.Query in TFS
I've got the following WIQL query for a TFS project:
string query = "SELECT * FROM Issue WHERE [System.TeamProject] = @Project "+
"AND [Assigned To] IN (@AssignedTo)";
Dictionary parameters = new Dictionary
Chris S
- 64,770
- 52
- 221
- 239
7
votes
1 answer
TFS API - WIQL - Query only returns id and url
I am trying to execute a WIQL query on TFS server (following this example) and get work items with the tittle and other fields. Even though I define the columns I want on the output, the json returned only with id and url.
Query
Select…
rbianchi
- 93
- 1
- 8
7
votes
1 answer
Using WIQL, how do you query VSTS Work Items on System.Tags
This is not an on-premise install, just VSTS. I'm new to working with the VSTS REST API and WIQL. I am trying to run a query that filters my work items on System.Tags = 'User Generated'. When I retrieve my Work Item, I can see in the…
Papa Burgundy
- 6,397
- 6
- 42
- 48
7
votes
2 answers
How to use LIMIT keyword as using in ms sql by WIQL to query TFS workItem
I'm working on TFS API, I don't know that TFS API have any things like LIMIT keyword or no.I need it for paging.
Thanks
knowwebapp.com
- 95
- 4
- 16
6
votes
1 answer
VSTS query by WIQL does not return requested fields
I'm building a Widget in VSTS and I'm calling the queryByWiql() method from Work Item Tracking rest client.
The query I have is:
queryString = {
"query": "Select [Microsoft.VSTS.Scheduling.RemainingWork]
From WorkItems
Where…
davidx1
- 3,525
- 9
- 38
- 65
5
votes
1 answer
WIQL tree query to get all parent work items from single child Id?
I have this WIQL...
Wiql wiql = new Wiql()
{
Query = string.Format("SELECT [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo], [System.State]" +
" FROM WorkItemLinks" +
"…
Jacob
- 323
- 1
- 7
- 16
4
votes
1 answer
TFS WIQL - Searchby keyword using TFS API and C#
Quick syntax question: I can return TFS items just fine using several other clauses, but I need to search by specific keyword. Query below:
WorkItemCollection results = wis.Query("SELECT [System.Id] FROM WorkItems WHERE [System.WorkItemType] =…
mynameisneo
- 473
- 5
- 12
- 23
4
votes
2 answers
Azure DevOps query for work items if any parent is in progress
I'm working on identifying all of our product backlog items that do not have a story point estimation. However, we have so many PBI(product backlog items) right now that need estimating. It is simply a mess. I need a query to help scop down the…
Luke Hammer
- 2,076
- 3
- 18
- 31
4
votes
2 answers
Using a Group By and Count statement in WIQL (Azure Dev Ops)
I want to make a WIQL query to count the workitems from the type 'Bug', grouped by the title and the software version fields. But, there is no group by function in WIQL. Does anyone have an alternative to make this work in WIQL?
SELECT
…
R Pelzer
- 1,188
- 14
- 34
4
votes
1 answer
How to Get the iteration path or iteration ID in TFS rest API?
I'm trying to get the tasks of a specific iteration. I know I can get that with the iteration path or the Iteration ID. I have this query:
SELECT *
FROM WorkItems
WHERE [System.WorkItemType] = 'Task'
AND [System.IterationID] = 24138
The…
Luis Rosales
- 123
- 1
- 1
- 9
3
votes
1 answer
How to retrieve wiki links attached to a Work Item
I am trying to extract wiki links from Azure DevOps using the azure-devops python package. Is this something feasible to do using WIQL? Retrieving item-to-item links can be done like this:
SELECT * FROM workitemLinks
WHERE…
JeffK3
- 107
- 7
3
votes
1 answer
Retrieving linked Work Items from Azure Devops, using WIQL
I have been looking into retrieving Work Items from Azure Devops with the azure-devops python package, and have managed to pull down work items with help from the sample code provided…
JeffK3
- 107
- 7
3
votes
1 answer
TFS WIQL Query with like condition
I need to write a WIQL query on TFS 2018 with a like condition in the field IterationPath like this:
SELECT
[System.Id],
[System.WorkItemType],
[System.Title],
[System.State],
[System.AreaPath],
…
TeoVr81
- 989
- 15
- 33
3
votes
0 answers
Get all children of the work item with WIQL
I have Azure DevOps work items (user stories and bugs), which are linked to epic work item called "Version 1" (Id 137).
Is it possible to retrieve only the children of this epic with Wiql?
Panu Oksala
- 3,245
- 1
- 18
- 28