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

Problem creating a report for pending approvals

I'm creating a report to show a list of pending approvals for work items. I would like for the report to show...

InternalApprovals.approver.name | ID | internalApprovals.Descriptors.name | internalApprovals.Descriptors.dueDate

I'm using the LiveSnapshot data source and the WorkItem table to get the data.

The issue is that In the case where a work item has two approvals with different approvers I get data like this

User1 | 1234 | Review1 | 9/17
User1 | 1234 | Review2 | 9/17
User2 | 1234 | Review1 | 9/17
User2 | 1234 | Review2 | 9/17

When I would expect

User1 | 1234 | Review1 | 9/17
User2 | 1234 | Review2 | 9/17

1

1 vote



One answer

Permanent link
I'm creating a report to show a list of pending approvals for work items.


I'm seeing the same thing. To be clear, in your example, User 1 is the only reviewer on Review 1. User 2 is the only reviewer on Review 2. However, when you retrieve a list of reviewers, you get two copies of each.

I'm using the live table com.ibm.team.workitem.WorkItem to get a list of approvals for a specified work item. In this case, the work item has 3 approvals:

...internalId | ...name | ...cumulativeStateIdentifier
_4k8RQXJ | Approval A | ...pending
_643GM2R | Approval B | ...approved
_s3DtMmR | Approval C | ...pending

In the work item, Approval A is for only User 1; Approval B is for only User 2; Approval C is for only User 3.

Then with a nested table, I retrieve the approvers related to that internalApprovalDescriptors.internalId. I see each user attached to that single review, incorrectly:

...name | ...internalId | ...name
User 1 | _4k8RQXJ | Approval A
User 2 | _4k8RQXJ | Approval A
User 3 | _4k8RQXJ | Approval A


Also, when I query the approvals based on a work item itemId, I see multiple references for each reviewer:

itemId | ...approver.name | ...internalId | ...name
_rvb-cH | User 1 | _4k8RQXJ | Approval A
_rvb-cH | User 1 | _643GM2R | Approval B
_rvb-cH | User 1 | _s3DtMmR | Approval C
_rvb-cH | User 2 | _4k8RQXJ | Approval A
_rvb-cH | User 2 | _643GM2R | Approval B
_rvb-cH | User 2 | _s3DtMmR | Approval C
_rvb-cH | User 3 | _4k8RQXJ | Approval A
_rvb-cH | User 3 | _643GM2R | Approval B
_rvb-cH | User 3 | _s3DtMmR | Approval C


This seems to be a bug in the reporting data. Am I missing something? I'll enter a work item unless someone can point out what's going on here.

0 votes

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.

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

Question asked: Sep 17 '10, 11:08 a.m.

Question was seen: 4,747 times

Last updated: Sep 17 '10, 11:08 a.m.

Confirmation Cancel Confirm