I am trying to retrieve information regarding the Salesforce Open Activities objects, but I am having problems making a load statement for that, in which only the data regarding the open activies for the object "Service Center Audit" can be retrieved.
The Salesforce admins have answered with this statement:
SELECT (SELECT SELECT AccountId, ActivityDate, Description, Owner.Name, Status, Subject, What.Name, Who.Name FROM OpenActivities Order By ActivityDate ASC, LastModifiedDate DESC LIMIT 500) FROM Service_Center_Audit__c
Does anyone know how to do that?
Julio César Lourenço