SLA Reports - Linking task_sla and Case

[Manuel Gomes]

I am trying to create a report that has a list of SLA's (task_sla) but as well data from the  Case table (sn_customerservice_case).

Has anyone managed to add Accounts (not company) and link this with the Task number?

[Dhianan · Accepted solution]

Hi Manuel

Task_sla contains the reference to the Task (case/incident etc). So the fields on Case table (sn_customerservice_case) are not available from the child tables, for reporting.

Suggest you introduce the database view between task_sla and the sn_customerservice_case tables. You may refer to the OOTB incident sla view below as an example.

Thanks

Dhianan

[Manuel Gomes]

Thank you! I was then able to create a report from the database view

Regards,

Manuel

[rebeccahanl]

Hi - what would be the Case Number formulation for the "where clause" ?