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

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

      Dears,

       

      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