Stack Overflow
Stack Overflow

Questions tagged [wiql]

Work Item Query Language

TFS Work Item Query Language is the syntax used by TFS work item queries

143 questions
3
votes
1 answer

How to query Work Item links with specified comment using WIQL

I need a fast way to get a list of links filtered by the link comment. Have a code: var linkCommentFilter = "Some link comment"; const string queryString = @"SELECT [System.Id] FROM workItemlinks …
Hopeless
  • 579
  • 1
  • 8
  • 25
3
votes
2 answers

Retrieve the WIQL of a saved query created in TFS

I have created a query in TFS interactively using the web interface. Now I want to get the WIQL that it is using. The only way I know how is to call the RESTful api, and pass $expand=wiql. Is there an easier way? Ideally from the interactive web…
John Henckel
  • 10,274
  • 3
  • 79
  • 79
3
votes
1 answer

Using TFS WIQL to get changeset IDs for a User Story?

Retrieving User Stories assigned to me WorkItemStore _WorkItemStore = (WorkItemStore) __ProjectCollection.GetService(typeof(WorkItemStore)); String _Query = @"SELECT [System.Id] FROM WorkItems where [Assigned to] = @Me AND…
Jack
  • 15,614
  • 19
  • 67
  • 92
3
votes
3 answers

In a TFS 2010 Work Item Query can I add two field values as the "Value"?

I would like to create a team query for our TFS users that shows all task items where the sum of the [hours remaining] and [hours completed] fields exceed the [original estimate] value. Now Whilst I can add a clause to the WIQL that compares one…
Pete Stensønes
  • 5,595
  • 2
  • 39
  • 62
2
votes
2 answers

How can I query TFS to get a list of changesets that need to be merged into a parent branch?

We are using TFS2010 for source control, the source repository has 3 main branches; MAIN, REL and DEV Consider this scenario: Several developers are working in the REL branch (fixing shipping issues). As they work their changes are checked into the…
Pete Stensønes
  • 5,595
  • 2
  • 39
  • 62
2
votes
3 answers

Invoke-RestMethod : The underlying connection was closed error in powershell script

I had written code in PowerShell to get the workitems of an area of a project by wiql. $token = "PAT" $url="https://dev.azure.com/Organizationname/_apis/wit/wiql?api-version=5.1" $token =…
Jennie
  • 225
  • 2
  • 13
2
votes
1 answer

Azure DevOps API WIQL get maximum max work item id

I'm using WIQL to query for a list of work items in Azure DevOps. However, Azure DevOps will return a maximum of 20000 work items in a single query. If the query results contain more that 20000 items, an error code is returned instead of the work…
Mike Collins
  • 402
  • 3
  • 13
2
votes
1 answer

How to search for TFS items that are in still in Refinement?

I am trying to create a search query to search for TFS items that are in Refinement from a TFS board and am stuck with that. Basically I want to be able to add a badge of amount of work items that are currently being displayed in the Refinement…
Deb
  • 737
  • 1
  • 5
  • 20
2
votes
0 answers

Is it possible to limit a TFS query to top 100?

Using TFS (hosted), I'm trying to create a query to show some stats about the top 100 product backlog items. I can add a condition to filter by the "Backlog Priority" field, but these numbers are arbitrary and the query would require constant…
Ivy
  • 887
  • 1
  • 7
  • 25
2
votes
2 answers

How to specify "date precision" when querying VSTS through a hyperlink

I am building an email report about VSTS work items where I have some links that should open VSTS queries. The WIQL query is passed as part of the hyperlink URL, see the following link: Define a query as a hyperlink I pass the DateTime as date and…
Nicolae Daian
  • 1,065
  • 3
  • 18
  • 39
2
votes
2 answers

MS VSTS Rest API's: Get List of Attachments for a given item

Using the Azure API's, I am able to get the content of an attachment using: GET https://dev.azure.com/fabrikam/_apis/wit/attachments/{id}?api-version=4.1 This assumes you know the guid (id) of the attachment you wish to download. What I am trying to…
dunkyduncs
  • 175
  • 1
  • 1
  • 8
2
votes
1 answer

Filtering a WIQL Query with C#

I need some help filtering a SQL WIQL query. How can I modify the code below to ignore the fields that have empty model values? For example if the user only wants to filter one field like the work item type and ignore the state field? Any help would…
Jeremiah Mora
  • 75
  • 2
  • 9
2
votes
2 answers

how to get all the Users along with Team Iteration of a project of TFS WIQL?

i want to get all the users with there Iteration in a project. Lets say Project 'Precient' has 9 distinct users with 20 iteration so i want distinct users with all the Iteration in the project WIQL C#.it's related to the Question. WIQL query to get…
user9461718
2
votes
1 answer

How to know if a ID has a parent ID or not in WIQL TFS?

I have an id and I want to know if has a parentid or not by C# coding for TFS. In my TFS board there are many user stories that do not include a Feature ? My hierarchical structure in TFS is as follows: Feature --->User Stories(u1,u2,u3) --->Tasks…
Deepak Jain
  • 137
  • 1
  • 3
  • 27
2
votes
1 answer

how to get Hiearchical structure in WIQL workitem

i have a hiearchial strurcture in TFS like this where a 1 Feature can have 'N' number of Product backlog items and single product Product backlogitem can have 'N' number of task/bugs tree structure Feature1-> PB1-> …
user8887761
1
2
3
…
9 10