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 |
One answer
![]() 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. |
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.