Incident Related List & Reporting

Dillin  Bradley
Tera Expert

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

6 REPLIES 6

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.

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