Having trouble getting the approval data from rtc into RPE
I am using RPE 2.0.1 and CLM 6.0.1. I would like to pull the approval data from a single work item.
Ultimately I would like the output to look like this: Approval Name Approver Status Review 1 Joe Pending Review 1 Sue Approved Review 2 Harry Pending Review 2 Tom Pending Review 2 Dick Pending Review 3 Jim Pending Icing on the cake would be the date the approver approved Thoughts? |
2 answers
I ended up with the following:
$290 = workitem/workItem/approvals/approvalDescriptor/approvals/approvalDescriptor $291 = workitem/workItem/approvals/approvalDescriptor/approvals/approver $292 = workitem/workItem/approvals/approvalDescriptor/approvals/approvalDescriptor Comments
Heather Linsk
commented May 04 '16, 2:59 p.m.
can't seem to post the image
Subramanya Prasad Pilar
commented May 05 '16, 2:08 a.m.
I had generated sample output before posting the screenshot. Please let me know if you are still unable to get the output. I can provide the sample template.
Heather Linsk
commented May 05 '16, 8:31 a.m.
I was able to get the information out.
Cesar Sasaki
commented Nov 28 '16, 6:01 p.m.
Hi Subramanya or Heather
Did anyone can upload a sample with the approval history please?
Regards |
You can simply use approvals element (com.ibm.team.workitem.Approval) as in the screen shot attached.
But icing this cake is not straight forward. :) You need to use JavaScript - add modified date (workitem/workItem/itemHistory/modified) to an array and find the date the approver approved. Comments
Subramanya Prasad Pilar
commented May 04 '16, 4:17 a.m.
You can test this using https://server:port/ccm/rpt/repository/workitem/workItem/id/123 as data source URL.
Heather Linsk
commented May 04 '16, 10:45 a.m.
First, thank you.
workitem/workItem/approvals/approvalDescriptor
|
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.