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

[Dr Atul G- LNG]

Hi @CarolMa6 May I know why you are creating a DB view for REQ/RITM and SCATALK? You can create a direct report on these tables instead.

[CarolMa6]

Hi @Dr Atul G- LNG 

There isn't a single table that shows Requests and their associated Requested Items alongside whether a Catalog Task was created or not. We want to build a report that highlights Requests and Requested Items where the Catalog Task is missing, so we can investigate why it wasn't generated. And also report on requests where the catalog task was created.

Regards 

CarolMa

[Dr Atul G- LNG]

Hi @CarolMa6 

We want to build a report that highlights Requests and Requested Items where the Catalog Task is missing

What do you mean by “missing”? Do you mean the RITM doesn’t have any tasks? If that’s the case, it is still possible to create a report directly on the RITM table.

Something like this.

[Dr Atul G- LNG]

Hi @CarolMa6 

Did you try my solution?