Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

 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

0 votes


Accepted answer

Permanent link
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

1 vote

Comments

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 

 If any one have please let me know..


2 other answers

Permanent link
Also look at:   Operational Data Store > Request Area > Request State History

1 vote


Permanent link
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

1 vote

Comments

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

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,015
× 403

Question asked: May 22 '13, 7:28 a.m.

Question was seen: 6,557 times

Last updated: May 23 '13, 10:00 a.m.

Confirmation Cancel Confirm