Databases
StackOverflow2013
Postsdbo
POIn TFS 2010 how can I search for a value entered into the note during check-in?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIn TFS 2010 how can I search for a value entered into the note during check-in?
    primarykey
    data
    text
    <p>We have a Team Project Collection Source Control Setting for Check-in Notes that requires each check-in to capture a "Tracking Number". This number is external to TFS. I need to search for all the changesets that have a specific Tracking number.</p> <p>The resulting changeset list tells me what to get latest version on, for a monthly deployment.</p> <p>We don't use Work Items.</p> <p>Question 1) Where in tfs_default_collection are the notes stored? One way to easily look would be to query with .SQL. I don't see "Note" in any of the database schemas.</p> <p>Question 2) If I can't use .SQL to search, what object reference in Microsoft.TeamFoundation.VersionControl.Client.dll will give me the details of the Check-in Notes?</p> <hr> <p>If I know what the changeset number is, then I can do something like this to give me the list.</p> <p>-- these are all the .slq objects checked in $Release on '2013-01-28'</p> <pre><code>SELECT chg_set.CreationDate, chg_set.ChangeSetId, v.FullPath FROM dbo.tbl_ChangeSet (nolock)AS chg_set INNER JOIN dbo.tbl_Version (nolock)AS v ON chg_set.ChangeSetId = v.VersionFrom LEFT OUTER JOIN dbo.tbl_File (nolock) AS f ON v.FileId = f.FileId WHERE chg_set.CreationDate &gt;= '2013-01-31' and FullPath like '%Tracker\Releases\2013.02.31%' and FullPath like '%.sql%' ORDER BY chg_set.CreationDate, v.FullPath </code></pre> <p>After some more digging into TFS_DefaultCollection I found it.</p> <p>I can join these results with the query above and see exactly what I am looking for.</p> <pre><code>SELECT ReleaseNoteId, FieldName, BaseValue from Tfs_DefaultCollection.dbo.tbl_ReleaseNoteDetails where ReleaseNoteId in (SELECT ReleaseNoteId FROM Tfs_DefaultCollection.dbo.tbl_ReleaseNote where DateCreated between '2013-01-18' and '2013-02-22') and FieldName = 'Tracker #' and BaseValue &lt;&gt; '0' -- base value of zero is a merge from $Main </code></pre> <p>Thank you, in advance.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser2025663
    1. USuser2025663
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POIn TFS 2010 how can I search for a value entered into the note during check-in?
      1. This table or related slice is empty.
      1. VTClose
    2. VO
      singulars
      1. POIn TFS 2010 how can I search for a value entered into the note during check-in?
      1. This table or related slice is empty.
      1. VTClose
    3. VO
      singulars
      1. POIn TFS 2010 how can I search for a value entered into the note during check-in?
      1. This table or related slice is empty.
      1. VTClose
    1. COpossible duplicate of [How do i find and view a TFS changeset by comment text](http://stackoverflow.com/questions/925875/how-do-i-find-and-view-a-tfs-changeset-by-comment-text)
      singulars
      1. POIn TFS 2010 how can I search for a value entered into the note during check-in?
      1. USJames Reed
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload