No records generation after creating a sc_request --> requested_item --> sc-task database view

[CarolMa6]

Hi 

I created a Database view but for some reason no records are generated i think my "where clause" is the issue. The business requirement is report on all requests, requested items and catalog task on one view. What am i missing please help.

Database View

1. View Table 

2. View Table 

3. View Table 

Regards 

CarolMa

[CarolMa6]

@Ankur Bawiskar 

Error:  invalid field or a field that is not visible (ritm_request)

my where clause for sc_req_item is not correct which field should i use here? ritm_request_item=req_sys_id does not work?

Regards 

CarolMa

[Ankur Bawiskar · Accepted solution]

@CarolMa6 

Don't add any field as View field under any of the View tables.

Then use the database view and click Try It

It should work fine then

If my response helped please mark it correct and close the thread so that it benefits future readers.