Approver Status - What Table for BIRT Report
I am looking for where the Approver Status for a Work Item is kept. I found approval info in the LIVE_WORKITEM_CNT, but there is not a field for the state of the approval by approver. Just APPROVAL_STATE which is for the whole work item. Which table do I need to join with to get this information?
One answer
The APPROVAL_STATE would have multiple entries one for each approval-state combination. Suppose a WI has approval status like this
Verfication
User 1 : Pending
User 2 : Approved
Review
User 1 : Approved
then you shall find 3 entries
Verfication
User 1 : Pending
User 2 : Approved
Review
User 1 : Pending
then you shall find 2 entries - one for each User 1 and User 2. APPROVAL_COUNT will be 2 for User 1 indicating 2 Pending states.
Verfication
User 1 : Pending
User 2 : Approved
Review
User 1 : Approved
then you shall find 3 entries
Verfication
User 1 : Pending
User 2 : Approved
Review
User 1 : Pending
then you shall find 2 entries - one for each User 1 and User 2. APPROVAL_COUNT will be 2 for User 1 indicating 2 Pending states.