Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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