Fetch incident table details from task_sla table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Then you should utilize the incident_sla instead of task_sla.
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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
