It's all about the answers!

Ask a question

Link between Approvals and Approvers


Steve Mulligan (1761321) | asked Dec 20 '12, 5:11 p.m.

I am trying to populate a data warehosue with Approvals and the Approvers for each Approval. 

The table WORK_ITEM_INTERNAL_APPROVALS contains the Approval information.

The table WORK_ITEM_INTERNAL_APPROVAL_DESCRIPTORS contains the Approver information.

Both tables have a filed JZ_PARENT_ID which link them to a Work Item.

Both tables also have a field INTERNAL_ID, which in most cases is the same for the two tables for the same Approval. However, there are cases where they are not the same. 

There are many cases where a Work Item has multiple Approvals, each with one or more Approvers.  I need to determine which Approvers link to which Approvals.

Example:

Approval 1

   Approver 1

   Approver 2

Approval 2

  Approver 2

  Approver 3

One answer



permanent link
Dmitry Karasik (1.8k11) | answered Jan 08 '13, 11:31 a.m.
JAZZ DEVELOPER
There is no way to relate approvers to approvals using the query model.

In the doc storage they are related by approval storing a descriptor id of the corresponding approval descriptor. However neither Approval.descriptorId nor ApprovalDescriptor.id are exposed in the query model.

In order to do this you would have to programmatically fetch the work item from the doc store and then write the corresponding data into your data warehouse.

Your answer


Register or 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.