It's all about the answers!

Ask a question

Having trouble getting the approval data from rtc into RPE

Heather Linsk (140124) | 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 (3.2k13) | 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 (140124) | 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.