Retrieving Primary Contact's Email Address from an Incident using ROQL
I am trying to retrieve the email address for the primary contacts assigned to a set of custom Incident types.
Currently I have the following which I believe is retrieving the incident ID.
SELECT I.PrimaryContact.Contact FROM Incident I WHERE I.CustomFields.c.incident_type.LookupName='EBS'
I have tried locating the email address using the Connect Object Explorer but have had no luck so far.
Could someone let me know the ROQL query I should be using to retrieve this or point me in the right direction?
Any help is greatly appreciated