how to get work item history report using report studio in RTC4 v. please let me know the details about what are the tables to be used
Accepted answer
Hi Sunanda,
This is pretty much straight forward.
Report Studio: Operational Data Store > Request Area > Request History, etc
Database table (view): RICALM.VW_RQST_HISTORY
Comments
Thank you @Kenji Sari, i have made one report which shows previous state and current state of wi But Is it possible to get who done the work item sate change ?
For example:- in web client if you click on "History" tab you will get to know who changes what, like wise i want to display the colum who done/change the wi satuses .
Please let me know is it possible or not ?
The 'Modifier Name' under 'Request History' will show you who made the change.
One other answer
, thank you for your Answer, but i didn't see Modifier name under 'Request History', only i can see "Name" and it results summary.
Request Area->Rqeuest Hitsory this is the path i have searched but no modifier name found.
is there any other way, where i can get modifier name ? in Report studio ?
