It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×11,924
×324

question asked: Aug 22 '12, 8:34 p.m.
question was seen: 4,794 times
last updated: Sep 05 '12, 7:16 a.m.

Related questions

FAQ - How this Forum works

Approver Status - What Table for BIRT Report

0
Robert Carter (429●2●85●89) | asked Aug 22 '12, 8:34 p.m.
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

Most liked answers|Newest answers ↓|Oldest answers

0
permanent link
ankur sharma (662●1●22●28) | answered Sep 05 '12, 7:16 a.m.
JAZZ DEVELOPER
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.


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.