Database views - dot walking
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago - last edited 2 hours ago
Hi ,
I have created the database views including the tables -
sc_task , sc_req_item & approval table
with below conditions -
on the report I want to dot walk for sc_task records the approver it has on related RITM record.
( like for eg; if RITM has abel tuter as a approver then for the related sc_task record that abel tuter should be visible under approver column ( as the its list report) )
unable to do it using filter conditions how to do it ??
can anyone help ??
thankss!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
if RITM has Abel Tuter as approver then this info is present in Approval table
How it related to sc_task?
what's your exact business requirement?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
43m ago
basically I have a report on the database view
so, we have RITM and related catalog task
it's a list report where we are showing the catalog task, there we have one additional column where we need to show the approvers of its parent RITM record.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
Can you try using appr_sysapproval=ritm_sys_id and make sure there is data that is matching the filter conditions in sysapproval_approver table
If this helped to answer your query, please mark it helpful & accept the solution.
Thanks,
Bhuvan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
39m ago
I tried using the same query but for the catalog task records it want showing anything hence I went ahead with above query...