Database view for task_sla, sc_task and incident tables

[Alina-Maria_S]

Hello everybody, 

I want to create a database view where to see data from the following tables: task_sla, sc_task and incident - as I need to be able to see all task_sla associated with Incidents and Catalog tasks on the same view, together with the Requested for Catalog task and Caller for Incidents. 

I have configured the Database as below:

But no records are displayed: 

Could you please help? 

[Alina-Maria_S]

Bu there is link between sc_task and task_sla and between incident and task_sla.

[Ankur Bawiskar · Accepted solution]

@Alina-Maria_S 

you create database view usually between tables which are linked to each other in some sense.

In this case incident and sc_task are not linked

Incident is something which is created for something not working

sc_task is created for catalog items

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

[Ankur Bawiskar]

@Alina-Maria_S 

Thank you for marking my response as helpful.

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