How to get task_sla fields in sc_task report

[Sri63]

Hi want to have task_sla fields in my sc_task table report.

Report: Test_report

Table: sc_task

I want to have these 2 fields (task sla fields) in my report related to that task

[Alikutty A]

Hi,

You can do the opposite here. Create a report on the Task SLA table and add the fields of your SC task by Dot walking on the Task field column. This should give you the required results.

Thanks!

[Alikutty A · Accepted solution]

Another alternative is to use the OOB database view named "sc_task_sla"

You can report on this table and add required fields from sc_task and task_sla tables on your list view.

Thanks!

[Sri63]

Got it . Thanks Ali

[Sri63]

What is i want to display Variables from sc_req_item  table. 

When I create report from task_sla or sc_tasl_sla , it is not accepting req item variables