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]

@Dr Atul G- LNG 

This does not give me any information related to requested item with missing catalog task. That is the report i want. 

Unless if the filter conditions i am using are incorrect. 

[Dr Atul G- LNG]

Hi @CarolMa6 

I tried on my end, and here is a list of RITM where no task as of now

[CarolMa6]

@Dr Atul G- LNG 

Doesn't work, brings up all the RITM records and there is no way of indicating there's a missing catalog task or a column showing that a task was not generated. 

[Dr Atul G- LNG]

Sorry mate, it seems I did not understand your requirement. or missing something. 

If you see my screenshot , which says that these are RITM where no task has been generated till now and. think this is what to you looking for .

[Ankur Bawiskar]

@CarolMa6 

your where clause for sc_task has issue, update as this, the correct field is request_item on SC Task which holds RITM

sctask_request_item = ritm_sys_id

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