Apex Code Development You need to sign in to do that
Don't have an account?
Srinivas VK export activity history of all cases more than 2 years old
How can I export activity history of all cases more than 2 years old into a .CSV file. I cant able to use the dataloader/workbench for this. what are all the alternatives?
I can able to run the below sample query from developer console i cant able to execute it in workbench.
Select (select Subject,Due_Date_SLO__c,activityType,CallBackEndTime__c,Status,Owner.Name,LastModifiedDate,Queue_Jumper__c FROM ActivityHistories) from Case where Id='5000c00001Wzaj6AAB'
I can able to run the below sample query from developer console i cant able to execute it in workbench.
Select (select Subject,Due_Date_SLO__c,activityType,CallBackEndTime__c,Status,Owner.Name,LastModifiedDate,Queue_Jumper__c FROM ActivityHistories) from Case where Id='5000c00001Wzaj6AAB'
you can create one report on Activity histrory object and you can export it to CSV.
Hope it helps you resolve this issue. If it helps, mark it as best answer please.
Regards,
Navin S
In Dataloader use the Export All button to export the data instead of normal Export option.
in the Filter you can use this Case record Id like whatId =: ' Salesforce Id' .
Thanks,
Maharajan.C