How to get task_sla fields in sc_task report

Sri63
Mega Expert

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

Report: Test_report

Table: sc_task

find_real_file.png

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

find_real_file.png

1 ACCEPTED SOLUTION

Alikutty A
Tera Sage

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!

View solution in original post

6 REPLIES 6

Reporting on variables is an entirely different thing, You will need to create a new database view b/w sc_task, task_sla and variable ownership table

Note that you wont get all the variables in a single record like task field values. For each variable there would be a separate record added in the table with its value.

Got it