Join problem task to problem to incident to SLA creating a database view

Yanhong Huang · ‎07-08-2024

I am creating the database view to Join problem task to problem to incident to SLA that can be reported on for things like: Problem task associated with disruptive incident has breach SLA.

May I know how to achieve？

Slava Savitsky · ‎07-09-2024

I don't think you need all 4 tables for that. It could be enough to join [problem_task] with [task_sla] and add a where clause to narrow the list down to just the problem tasks that are children of problems records associated with a disruptive incident.

To get an idea how to join [problem_task] with [task_sla], take a look at database views [incident_sla] or [problem_sla] that are available in the base system.

Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/

View solution in original post

Yanhong Huang · ‎07-09-2024

May I know how to add a where clause to narrow the list down to just the problem tasks that are children of problems records associated with a disruptive incident?

I created the database view for task_sla and problem task, but I still cannot get the disruptive incident record.