Incident Related List & Reporting

Dillin Bradley
Tera Expert

‎11-12-2024 10:23 AM

Hopefully an easy answer. I am having trouble in excluding Incidents in reporting. I'm looking to report off of Incidents that DO NOT have a Request created through it. I am able to report INCs that have REQs created from them but I'm not sure how to filter to an empty related list report of INCs

0 Helpfuls
  • 518 Views
6 REPLIES 6

AshishKM
Kilo Patron
Kilo Patron
In response to Dillin Bradley

‎11-14-2024 10:16 AM

Ok, so aprat from INC and REQ table, do you have other m2m table.

In such case, create new DB View on incident & m2m table and exclude all INC which match in m2m table.


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution
0 Helpfuls

Dillin Bradley
Tera Expert
In response to AshishKM

‎11-25-2024 05:36 AM

I am unsure how to create this. I have the view created but am unsure on the Where clause. Any idea?

0 Helpfuls