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

Mon, 26 Jan 2026 16:26:21 GMT

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

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

Fri, 12 Dec 2014 06:35:22 GMT

Hello, you can not make a relationship table within salesforce from qlikview.

Sebas

topic Writting Select (SQL) for Salesforce Tasks (Open activities) in QlikView

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

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