It's all about the answers!

Ask a question

Having trouble getting the approval data from rtc into RPE

Heather Linsk (1422252) | asked May 03 '16, 4:04 p.m.
edited May 03 '16, 4:08 p.m.
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


2 answers

permanent link
Subramanya Prasad Pilar (4.6k16) | answered May 04 '16, 4:13 a.m.
You can simply use approvals element ( 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.

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.
You may refer
I have not tried using ApprovalDescriptors element, you can also try that.

Heather Linsk commented May 04 '16, 10:45 a.m.

First, thank you.
Second, can you post the query for $5 and the full path of the text for that cell?

My next step is to figure out the item history.

Thanks again!

Subramanya Prasad Pilar commented May 04 '16, 12:39 p.m. | edited May 04 '16, 12:46 p.m.


permanent link
Heather Linsk (1422252) | answered May 04 '16, 2:58 p.m.
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

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.
Now on to the dates.

Thank you!

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?


Your answer

Register or 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.