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

Connect Object Explorer and ROQL confusing me.

Received Response
24
Views
6
Comments
edited Jan 23, 2018 9:07PM in Integrations and APIs 6 comments

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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