AnsweredAssumed Answered

Approver details

Question asked by Tahir Ahmed on Mar 7, 2017
Latest reply on Mar 10, 2017 by Amit Khatua
  • Comment • 1

Hello,

 

Need Approver ID and Name for particular CR from back-end database, which table or view has this info.

check most table related CHANGE_REQUESTS, did not find approver details.

 

Thanks

Amit Khatua
Amit Khatua Mar 10, 2017 5:39 AM
Correct Answer

Get the WORKITEM_ID from CHANGE_REQUEST and do a join to CHANGE_REQUEST_WORK_USER to get the ID of the appover

 

Hope that helps

 

-Amit

See the reply in context
No one else had this question

Outcomes