Fetch incident table details from task_sla table

[Shweta601344212]

Hello,

I am trying to create a report on the task_sla table. In the report, I want to include columns from the incident table i.e. incident like Severity in the available columns list. but is not available as of now.

Please hep me achieve it.

[AndersBGS]

Hi @Shweta601344212 

Then you should utilize the incident_sla instead of task_sla.

[Deėpak Sharma]

hi @Shweta601344212 

The reason you aren't seeing Incident fields directly is because the task_sla table references the base task table, not the incident table. To get to the Severity field, you need to dot-walk to the extended table.
It will usually display as Task.Incident.Severity (or just Task.Severity) in your column headers.

Happy to help! If this resolved your issue, kindly mark it as the correct answer ✅  and Helpful and close the thread 🔒 so others can benefit too.

Warm Regards,

Deepak Sharma

Community Rising Star 2025