You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to show matching incident rows from two different join tables?

Received Response
41
Views
6
Comments

We're working on a project where we want to add contacts to an incident, but we can't use secondary contacts because we don't want to automatically send emails to them. (That's a separate issue that needs to be addressed.)

So, we've created a custom object to hold these secondary contacts. Basically, it's a join table to link contact ids and incident ids, just like inc2contact. Let's call the table OBO.

We want a report that shows all incidents related to a contact, whether they are the primary contact or a secondary contact that is associated via the OBO table. So, we'd be filtering by contact ID (or other contact fields).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!