Stack Overflow
Stack Overflow

Questions tagged [tfs-query]

22 questions
7
votes
1 answer

VSTS find workitems between two releases

To compare the related work items between the current release and a previous release I can use the following: Is there possible to create a query to get the same work items between two releases? Or alternatively the VSTS Rest API. My reason for…
Ralf de Kleine
  • 11,464
  • 5
  • 45
  • 87
5
votes
1 answer

Include user parameter in a work item query

I would like to create a work item query where the user is always asked to pass the value of the argument he wants. For example: Team project= @Project And Work Item Type = Bug and State = ? Then the user is asked for which state he wants to get…
PatriceVB
  • 1,053
  • 1
  • 10
  • 28
2
votes
2 answers

Sort TFS Query By Itaration Start Date

I have TFS/AzureDevOps query which is sorted by Iteration Path . I need to sort it by Iteration Start Date. I dont see any option on the Sorting Page or in the query page to sort like this. I tried sorting by iteration ID but the iteration were…
galsi
  • 421
  • 1
  • 6
  • 19
2
votes
1 answer

Re-organize Charts in VSTS Queries

I've created a few charts in a VSTS Query but I can't figure out how to re-organize them. Is that possible? For example, I want to move 'Task Person Status 2' to the right of 'Task Person Status'.
spottedmahn
  • 14,823
  • 13
  • 108
  • 178
2
votes
1 answer

in TFS, how to query items by project name?

I have a team foundation server and on it there are two projects, named GD and DS. Now I'd like to create a query which list all the unfinished job of one project, either GD or DS. The current filter is: Team Project = @Project I don't know what…
Felix
  • 2,673
  • 3
  • 30
  • 38
1
vote
1 answer

Can I hide parents with no children in a TFS query of the "tree of work items" type?

As the title says, I have a "tree of work items" query that shows all parent work items ("Initiatives") that have a certain State (here: Closed) with their respective children which are not closed, so it looks something like that: Parent 1 [Closed] …
Gorgsenegger
  • 7,356
  • 4
  • 51
  • 89
1
vote
0 answers

Can I query TFS Discussion column?

I want to query the Discussion column of a TFS task. I use Visual Studio 2012 Professional Edition. Now, I am only able to fetch entire history column. The 'Discussion' column which is inside of 'History' is not available when creating a new…
TkTech
  • 37
  • 7
1
vote
0 answers

How can I return derived fields by using TFS 2013 query

We have an Application on Reporting on TFS items. I am using Query against TFS and fetching the tfs items. I am using below query "Select [ID], [State], [Title], [Work Item Type], [Severity] " + "From WorkItems " + @"Where ([Area Path] Under…
Babu
  • 285
  • 1
  • 4
  • 15
1
vote
1 answer

Get all TFS work items I have worked with in TFS2013

A work item is often ended in QA hand so its "Assigned To" field is normally a QA's name not the developer. As a developer, how can I find all the work items I had worked on? I tried "History Contains Word @me", it returns far less items I…
hshen
  • 468
  • 1
  • 4
  • 13
1
vote
1 answer

How to write tfs work item query for fetching workitems which are under more than one iteration path

I want to write a tfs work item query like below (Team project = @Project) AND (Assigned to = user1 OR Assigned to = user2 OR Assigned to = user3) AND (Iteration path under path1 OR Iteration path under parth2) Please help me in achieving the…
Ashish
  • 437
  • 1
  • 4
  • 10
1
vote
1 answer

Query TFS2010 for Test Cases without steps

I'm copying test cases from one project to another in TFS2010. Some of the test cases have a state of "Ready" and they have no steps. I would like to make sure that those test cases can easily be found so I can change their state back to "Design".…
Demitrius Nelon
  • 1,210
  • 1
  • 10
  • 29
0
votes
1 answer

TFS query Column option not showing all the columns

I have a column in WIT (work item template) named " Planned end date" and Reference as "SV.Deadline" . But when i create a query, and want to add this column to appear in query through "Column Options" , i do not find this column in the list. Can…
Dipti Mehta
  • 537
  • 3
  • 13
0
votes
1 answer

DevOps query unable to exclude work items that contain specific set of tags

I have 4 DevOps tags and 3 scenarios: Work items that only contain 1 out of the 4 tags Work items that contain all 4 tags Work items that contain more than 1 but less than 4 I'm trying to build the following queries and having issues with…
Cordelle
  • 1
  • 1
0
votes
1 answer

Fetch List of User Ids From Nested Collection in Firestore Database using TypeScript (NestJs)

I am working on firestore and my firestore collection structure as below: Users-> userId1 -> UserDetails -> User_Info -> JSON Data Users-> userId2 -> UserDetails -> User_Info -> JSON Data Users-> userId3 -> UserDetails -> User_Info -> JSON…
Shubham Verma
  • 8,783
  • 6
  • 58
  • 79
0
votes
2 answers

TFS Query for Features not 'Done' but all child User Stories are 'Done'

Anyone know how to write a query in TFS that will show any Features whose State is not 'DONE' but whose child User Stories or similar are 'DONE'?
David Evans
  • 11
1
2