Database View to join tables sysapproval_approver and sc_req_item
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-14-2013 06:11 AM
Has anyone joined these tables sysapproval_approver and sc_req_item, and how?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-14-2013 06:14 AM
I tried joining the two tables Approval[sysapproval_approver] & Requested Item[sc_req_item] where the Approval Table sysapproval equals Requested Item Table sys_id. But it seems I am missing records. Does anyone else have a better way?
Thanks,
Andy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-14-2013 02:50 PM
Will you provide more background on what you are trying to accomplish? Typically you can do a glide lookup to figure out who approved a REQ/RITM/Task
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-26-2013 05:05 AM
I am trying to create a Database View to join tables Approval[sysapproval_approver] & Requested Item[sc_req_item] so our ECS, Security, Client Support and IS Tools support teams can run a report that will tell us all open sysapproval request not yet approved and will provide us the contact persons.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-08-2023 12:59 PM
Were you able to find a solution to this requirement?
