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

Having trouble getting the approval data from rtc into RPE

Questions
Tags
Users
Badges
Heather Linsk
(142●23●52) 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?

0 votes

2 answers
3,753 views
0 votes

2 answers

Permanent link
Subramanya Prasad Pilar
(4.6k●1●6) 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.

0 votes

Comments
Subramanya Prasad Pilar
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
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
May 04 '16, 12:46 p.m.

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

Permanent link
Heather Linsk
(142●23●52) 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


0 votes

Comments
Heather Linsk
May 04 '16, 2:59 p.m.

can't seem to post the image

Subramanya Prasad Pilar
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
May 05 '16, 8:31 a.m.

I was able to get the information out.
Now on to the dates.

Thank you!

Cesar Sasaki
Nov 28 '16, 6:01 p.m.

 Hi Subramanya or Heather

Did anyone can upload a sample with the approval history please?

Regards

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.

Ask a question
Guidelines
FAQ
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
× 10,926
× 456
× 332

Question asked: May 03 '16, 4:04 p.m.

Question was seen: 3,753 times

Last updated: Nov 28 '16, 6:01 p.m.

Confirmation Cancel Confirm