0

I've been looking in the TFS_Default Collection and TFS_Warehouse database's but haven't had any luck.

TFS Task Image

Any advice or tips would be greatly appreciated.

jessehouwing
  • 106,458
  • 22
  • 256
  • 341
Daniel Gibson
  • 11
  • What are you trying to do with this information? You **should not** write queries against TFS operational store databases (i.e. `tfs_defaultcollection`). – Daniel Mann Jan 03 '20 at 13:51
  • Short answer: Just query it, the user I've got set up has Read only. Long Answer: Create C# Web app that will be able to search for strings depending on what team the user is a part of. – Daniel Gibson Jan 03 '20 at 13:57
  • Then the actual solution to your problem is to use the REST APIs to run a WIQL query. The database schema is undocumented and subject to change, and querying it directly isn't an option at all in Azure DevOps. If you want to make your solution maintainable and portable, then use the REST APIs. – Daniel Mann Jan 03 '20 at 14:40
  • Thank you I'll be sure to look into those :) – Daniel Gibson Jan 03 '20 at 14:52
  • @DanielGibson Have your checked the answer from @Shamrai? Is it helpful? – Cece Dong - MSFT Jan 10 '20 at 09:08

1 Answers1

1

TFS_Warehouse does not contain multi-line text fields. For TFS_DefaultCollection, it is not recommended to use operational databases because that may affect TFS performance. Consider to use Rest API:

  1. Work Items
  2. Comments

You can use nuget package Microsoft.TeamFoundationServer.Client, Samples

Shamrai Aleksander
  • 13,096
  • 3
  • 24
  • 31