Having trouble getting the approval data from rtc into RPE

Heather Linsk (140●15●50) | 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

Thoughts?

2 answers

Most liked answers ↓|Newest answers|Oldest answers

permanent link

Heather Linsk (140●15●50) | 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

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.
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?

Regards

permanent link

Subramanya Prasad Pilar (4.6k●1●4) | answered May 04 '16, 4:13 a.m.

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.
You may refer https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI
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.

workitem/workItem/approvals/approvalDescriptor
workitem/workItem/approvals/approvalDescriptor/name

It's all about the answers!

Related questions

Having trouble getting the approval data from rtc into RPE

2 answers

Your answer