How to Dot-Walk from sysapproval_approver to sc_req_item?

gk24
Tera Contributor

I would like to use the Report Builder (in London) to generate a more detailed report for users regarding their approvals.

I am able to get everything I need from the sc_req_item table but need to dot-walk to the approval table to obtain the pending requests for the specified user. Would appreciate any advise and thanks in advance! 

I've read that 1-M relationship between approver and req_item means it's not doable but there is only one approver on the form.

5 REPLIES 5

Debbie Balmos
Tera Contributor

I know this is quite old, but i am having this same issue trying to dot walk to the vendor forms and other fields in the ast_contract table.  I dot walked using the Approval for, and I see the fields.  I add them to the report, but they all show up as empty.  Is something else required in order to see other tables/fields from the sysapprover table?