+ Start a Discussion
Sfdc11Sfdc11 

SubQuery with ActivityHistory

Hi,

 

How to get the subquery output of activityhistory in a list & display in VF page.

 

[Select Id,caseNumber,(SELECT id,ActivityDate,Subject,Status,Description from ActivityHistories) from Case where Id=:caseId

 

Help me out..

 

Thanks in Advance!!

sf@143sf@143
Case c = [Select Id,caseNumber,(SELECT id,ActivityDate,Subject,Status,Description from ActivityHistories) from Case where Id=:caseId LIMIT 1][0];
ActivityHistories[] activityHistories = case.ActivityHistories;