Who changed the workitem in WORKITEM_CHNGS?
Hello,
I created a report (RTC 2.0.0.2) which gives me changes to the "Time spent" of my workitems. The problem is that I need to know who changed the value, but WORKITEM_CHNGS only gives me the current owner. When I look at the history page of a workitem, I can see who changed what - so the information must be there somewhere... How can I get it?
Thanks!
Martin
I created a report (RTC 2.0.0.2) which gives me changes to the "Time spent" of my workitems. The problem is that I need to know who changed the value, but WORKITEM_CHNGS only gives me the current owner. When I look at the history page of a workitem, I can see who changed what - so the information must be there somewhere... How can I get it?
Thanks!
Martin
2 answers
RTC currently does not ETL who changed the work item. Adding extra dimensions to the data we already ETL will increase the size of the data significantly. We also have a certain unease storing trend data about individuals as this could be ethically incorrect in certain places in the world.
As the author said, the information already can be viewed in the history tab. So it must be stored in a table. Im also interested in finding this information.
The other solution i thought of was to restrict a user from updating the time spent in a working item that doesnt belong to him.
Anyone know if any of the two is possible?