Database views - dot walking

[tushar_ghadage]

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!!

[Ankur Bawiskar]

@tushar_ghadage 

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.

[tushar_ghadage]

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.

[Bhuvan]

@tushar_ghadage 

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

[tushar_ghadage]

I tried using the same query but for the catalog task records it want showing anything hence I went ahead with above query...