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? 

[AndersBGS]

Hi @Alina-Maria_S ,

Basic for seeing incidents and SLAs associated to incidents you can utilize the incident_sla OOTB database view that there is available. 

According to your other requirement for sc_task and incident, how are these associated together? or do you mean incident_task instead of sc_task?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Alina-Maria_S]

Hi @AndersBGS ,

Thank you for replying. The requirement is to have on the same list displayed SLAs associated with Incidents and Catalog Tasks with the possibility to add on the list following fields: Requested for (for Catalog Task) and Caller (for Incidents). 

Kind regards,

Alina 

[Ankur Bawiskar]

@Alina-Maria_S 

you can join task_sla with incident and task_sla with sc_task

what's the link between incident and sc_task?

[Alina-Maria_S]

@Ankur Bawiskar , there is no link between incident and sc_task. Without the link between them, I cannot use the database view?