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
2
votes
1 answer

In TFS, how can you write a query offset a date by a separate field?

In TFS, you can set up a work item query with a date offset like Date > @Today - 7 Is is possible to use another field as the offset instead? Like, say you have [CustomOffset] that is an Integer. Is it possible to do something to the affect…
whoknows
  • 395
  • 2
  • 4
  • 17
2
votes
2 answers

WIQL Query not including "System.AssignedTo" Field

I have this WIQL, who's purpose is to find the user assigned to the work item. var wiql = string.Format("SELECT [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo], [System.State]" + " FROM WorkItems"…
Jacob
  • 323
  • 1
  • 7
  • 16
2
votes
1 answer

TFS WIQL does not support 'Does Not Contain'. Is there an alternative?

Here is something that I can do from Visual Studio, but cannot seem to do through the TFS API using WIQL. SELECT * FROM WorkItems WHERE WorkItemType = Bug AND Tags CONTAINS 'MyTag' AND Tags DOES NOT CONTAIN 'OtherTag' How do I query with a 'DOES…
Phillip Scott Givens
  • 5,256
  • 4
  • 32
  • 54
1
vote
1 answer

WIQL - Querying description for exact phrase

in TFS I am struggling to produce a query that searches the description field for an exact phrase e.g. "DO 1.2". The query matches both DO and 1.2 and DO1.2 when I really want to just match the exact string. Sample of the clause in the…
Malachi
  • 33,142
  • 18
  • 63
  • 96
1
vote
1 answer

Use WIQL to retrieve the results of a Team Query in TFS

Is there a way to retrieve the contents of a Team Query using WIQL? Background: I'm throwing together an RSS feed for new bugs entered into TFS. I could write a specific WIQL query for which work item types and states to include, but I'd rather…
James Orr
  • 5,005
  • 7
  • 39
  • 63
1
vote
2 answers

Retrieving changesets form a work item programmatically

I need to try retrieve a list of changesets that are linked to certain work items and display info on them in the program. But I'm having a lot of trouble figuring it out. I have been searching the internet extensively for 4 days and have come up…
Luke Clark
  • 13
  • 2
1
vote
1 answer

How to display date difference in WIQL query?

I am trying to display the time taken to close the user story via WIQL query, but getting an error as incorrect query, can anyone please let me know how to to do. Query: SELECT [System.Id], [System.WorkItemType], [System.Title], …
Naveen Kumar
  • 1,266
  • 1
  • 21
  • 50
1
vote
1 answer

Can you query Azure DevOps ChangedDate for a date range

I am trying to use the Azure DevOps WIQL to pull a list of work items that have change during a particular date range. I know that you can pull the work items from a certain date till today, but I want to be able to query a range. Doing something…
Jamie Nicholls
  • 55
  • 1
  • 10
1
vote
0 answers

get all my features + stories from all AND all my stories connected to other features

This question is about Azure Boards and querying Work Items. My use case is: I have different projects set up epics and features are maintained in a global planning project stories life in the product projects the final setup will be quite huge…
J J
  • 398
  • 1
  • 2
  • 13
1
vote
2 answers

azure-devops-node-api: Trouble calling queryByWiql() function with WIQL argument

first question here. I am developing a program that needs to query my azure devops organization and return a list of work item references filtered by System.Tag and System.TeamProject. To do this, I decided to use azure-devops-node-api's…
E092218
  • 11
  • 3
1
vote
1 answer

WIQL or query to get all related work-item, but NOT listing the parents

I have a query listing all features and their child/related work-items. Is there a way not to display the features (parents) itself? Just a flat list of all work-items having a link with a feature in this project.
Jan van Veldhuizen
  • 449
  • 3
  • 10
1
vote
1 answer

Azure DevOps Querying all PBIs in an Epic

I try to query the work item data to get a flat list of PBIs that belong to a given Epic with a parent relation ship Epic > Feature > PBI. Wiql seems to be limited in this regard, I can't find a "join" clause. In SQL, I'd do it somehow like this…
infero
  • 843
  • 2
  • 11
  • 22
1
vote
1 answer

WIQL nested queries

In ADO I have a single parent work item with child work items. The children work items, in turn have related work items. The number of child items will grow as time progresses. What I'm trying to get is the list of the related work items. This would…
Chris
  • 352
  • 1
  • 6
  • 16
1
vote
1 answer

get pull request information for a workItem in DevOps API

I wanted to know the status of the pull request associated with a work item on the board. If possible able to filter on status. Or At minimum Is it possible to get the pull request details with WIQL.
Pavan k
  • 48
  • 10
1
vote
1 answer

How do I write a TFS 2010 Work Item query clause whos value is a field value?

I think this question may be spawned from lack of knowledge, but here we go... I am trying to write a new team query (using the new query option of team explorer, in VS 2010) what I want is fairly simple; essentially a list of work items whos…
Pete Stensønes
  • 5,595
  • 2
  • 39
  • 62
1 2
3
…
9 10