Join incident, sc_req_item and incident_task tables

[Kristoff15]

For reporting purposes, I need to be able to join all three tables so I can sum the amount of tickets handled by a certain group. I'm having troubles figuring it out using the Database View.

[Prithvi_b · Accepted solution]

Hi @Kristoff15 ,

For joining 2 or more table, we should have a common Key for the connection. For example : "Incidents_sys_id=inctask_incident"(Incident and Incident task), which can be given in Where Clause in a Database View. But if you don't have any key element, we can create report on Task Table and in filter , we can give task type as incident/incident_task/sc_req_item.

(Attaching Screenshot)

Thankyou,

prithvi

[Kristoff15]

This works great! thanks never realized it would be this easy 🙂