Connect Object Explorer and ROQL confusing me.
So I'm trying to create an ROQL query to pull open incidents assigned to a specified contact. I know using a report would probably be easier but I've multiple environments and multiple interfaces and its a whole load of bother!
I've been investigating the Connect Object Explorer and find that its not as straight forward as it seems. Under the Incident object theres a PrimaryContact Object, when I try and run "Select Incident.PrimaryContact from Incident where id = 8241264" I get "Non-existant column: 'PrimaryContact'".
Am I misunderstanding this system?
I read through the community and found someone suggesting using the Contact object with the PrimaryContactIncidents object, but couldnt find reference to PrimaryContactIncidents anywhere.