Add "Assigned to <> [user]" line in multiple TFS Queries

Question

Hi, I'm using Visual Studio 2008 - Team Explorer where I have the following problem:

I'm using 15 Team Queries to show a selection of Work Items (each query shows different work items). In each query I exclude a couple of users (Assigned to <> [user]).
When another user has to be excluded from the Query, I have to manually modify all 15 Queries to exclude that user.

I'm looking for a way to only have to modify a single query and let the other 15 queries refer to that query (preferable), or a way to automatically add a query line to each of the 15 Queries.

Anyone?

Answer 1

Hi Kloppie,

Team Explorer does not support your requirement directly. To do this, there are 2 ways.

Way1: Create an application that use TFS API to get specified Team Query and modify them.

Way2: Open SQL Server on Data Tier, TfsWorkItemTracking.StoredQueries, edit the specified query text.

Best Regards,
Ruiz

---

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi