How to create a Report on all interaction with no incident and request

[Jyoti Tripathi]

How to create a report which give us all interactions that did not generate an incident or a request. May be I need to create a DB view? Let me know what is the where clause and join condition i should give that justify my requirement.

[NikEng1 · Accepted solution]

Hi,

You can use a related list condition on the related list "Interaction Related Records". Specify the return to be equal to 0 and check for all related records of type incident or request. This works when reporting on the interaction table:

Hope this helps!