1 Reply Latest reply: Dec 12, 2014 1:35 AM by sebastian gonzalez RSS

    Writting Select (SQL) for Salesforce Tasks (Open activities)



      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?



      Thank you,


      Julio César Lourenço