How to Dot-Walk from sysapproval_approver to sc_req_item?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-09-2020 06:51 AM
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.
- Labels:
-
Multiple Versions
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-30-2022 02:43 PM
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?