Using the predefined system fields, I would like to add on who created the work item, date of creation, the last person to modify it, and when the last modifications were made.

This is not a problem .. or is it?

It seems that System.ChangedBy is being populated with the "currentuser" who is viewing the work item regardless if he/she has made any changes rather then the the last user who commited changes to the system.  System.ChangedBy is updating PRIOR to the save and commit.

Interesting enough the field System.ChangedDate is not being populated with the current date that the work item was opened, but rather when the last changes were commited.  The System.ChangedDate updates AFTER a save but prior to the commit.

So how does one actually retrieve the value stored in TfsWorkItemTrack.dbo.WorkItemsLatest.ChangedBy field in the backend server for a given work item without having the true value of the field overwritten by your own name?

Try using Fields["System.ChangedBy"].OriginalValue - it should give you the right name.

Thanks,

Alex

I must apologize, it would have been much more informative to state that I was trying to update a work item (like Bug.xml).

Field Definition

<FIELD name="Changed By" refname="System.ChangedBy" type="String" reportable="dimension">
<VALIDUSER />
</FIELD>

Form Declaration

<Control Type="FieldControl" FieldName="System.ChangedBy" Label="Changed By:" LabelPosition="Left" ReadOnly="True"/>

Using the above in a work item will give the results I stated in the first post. The ChangeBy field is populated with the person viewing the work item whether they have saved it or not, rather then the true value stored in the db.

Changed By is a special system field, which is populated automatically. Unfortunately this behavior is not configurable.

Thanks,

Alex