It's all about the answers!

Ask a question

Can we create insight or any other report on Previous state and Current state of the Workitem Workflow ?


YOGESH LOKHANDE (10441926) | asked May 22 '13, 7:28 a.m.
retagged May 22 '13, 8:47 a.m. by Francesco Chiossi (5.7k1719)
 Hi ,

Can we create report like we see the history detail of work item .

or Can we create insight or any other report on Previous state and Current state of the Work item Workflow ?

Regards,
Yogesh

Accepted answer


permanent link
Francesco Chiossi (5.7k1719) | answered May 22 '13, 8:45 a.m.
edited May 22 '13, 8:46 a.m.
Hello Yogesh,

in Insight / RRDI you have the Work Item history available in the data model under:
Operational Data Store > Request Area > Request History

For every Work Item there is a row for each entry in the RTC Web UI History tab, containing the corresponding information at the time of the History entry.

The current state of the Work Item is available in the data model under:
Operational Data Store > Request Area > Request

Best Regards
YOGESH LOKHANDE selected this answer as the correct answer

Comments
YOGESH LOKHANDE commented May 23 '13, 6:45 a.m.

Thank you Francesco ,


But I need the detail information of history tab of work item in report ....

like

WI Id |  Summary |  Assigned to  | State |  Previous State | Current State | Duration of State transition | Modified by | 


Thanks,
Yogesh 


YOGESH LOKHANDE commented May 23 '13, 6:45 a.m.

 If any one have please let me know..

2 other answers



permanent link
Jackie Albert (1.6k14744) | answered May 22 '13, 9:56 a.m.
Also look at:   Operational Data Store > Request Area > Request State History

permanent link
Francesco Chiossi (5.7k1719) | answered May 23 '13, 7:19 a.m.
edited May 23 '13, 7:20 a.m.
Hello Yogesh,

some information regarding the details you are looking for
  • WI Id : Request History > Reference ID or Request State History > External Key1
  • Summary : Request History > Summary or Request State History > Request Name
  • Assigned to : The closes field I can think of is Request State History > Owner ID that you have to match against Resource Area > Resource > Resource ID
  • State : Request State History > Request State or Request History > Request State
  • Previous State : Request State History > Previous Request State
  • Current State : Request State History > Request State
  • Duration of State transition : Request State History > Days In State
  • Modified by : I don't think this is available in the data warehouse

Best Regards


Comments
Jackie Albert commented May 23 '13, 10:00 a.m.

I think the 'Modified By' is coming with the CLM 4.0.3 release.

Your answer


Register or to post your answer.