how to report on SLA definition linked to requested item?

RockP
Mega Contributor

‎11-10-2025 12:26 AM

I'm trying to join the 3 tables sc_req_item,  task_sla, sc_cat_item to report on the SLA definition linked to the requested item without success. is there something wrong with the database view I created?

Preview file
96 KB
0 Helpfuls
  • 238 Views
1 REPLY 1

AndersBGS
Tera Patron
Tera Patron

‎11-11-2025 08:52 PM

Hi @RockP ,

 

why don’t you just dot-walk from task_sla —> sc_req_item —> sc_cat_item instead of creating a database view and joining all of them?

 

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/

0 Helpfuls