Apex Code Development You need to sign in to do that
Don't have an account?
Andrew Aldis How can I query activity history
I am trying to write a query that pulls a list of account Owners and their activity history then aggregates the activity histry using count(), but it will not let me count on a sub query. I am also not able to query the activity history without querying the account. Is there a way around either of these restrictions?
Select
(SELECT OWNER.Name
FROM ActivityHistories
where (ActivityType = 'Discovery Demo' ) OR (ActivityType = 'Discovery Interview')
)
From Account
Where Target_Account__c = True OR Target_Prospect__c = True
Select
(SELECT OWNER.Name
FROM ActivityHistories
where (ActivityType = 'Discovery Demo' ) OR (ActivityType = 'Discovery Interview')
)
From Account
Where Target_Account__c = True OR Target_Prospect__c = True