Database views question for Reporting purpose

[Happy S]

As per subject I am trying to create a database views for reporting purposes.

I wanted to run a report for Task SLA

but the issue is:

- the Task SLA is only at RITM level 

- at SCTASK level there are no SLAs attached

So based on the above, I tried to combine both OOBs views - sc_request_sla and sc_task_sla but I cannot seems to make it work.

Any help is appreciated.

Thank you !

[Ankur Bawiskar]

@Happy S 

so basically you want to join sc_task, sc_req_item and task_sla?

[Happy S]

Hi Ankur,

Yes you are right..

[Ankur Bawiskar · Accepted solution]

@Happy S 

if yes then check this link where Jaspal has explained it for HR case, HR Task and Task SLA.

Do something similar for your case, below image is from the same link

how to join sc_task, task_sla and sc_req_item tables 

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