function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
App DevelopmentApp Development 

how to export Accounts with activity history?

I have tried with exporting accounts with activity history using reports.
but, is there any other way to do the same.?

i see there is no correct data exported. could you please suggest on this?
Rowallim TechnologyRowallim Technology
Hello App Development,
 
Yes you can do it through Data loader.
I assume by activity history you mean the TASKS and Events associated with the accounts.
 
if so you can do something like this for tasks
 
Select What.Type, t.CreatedById, t.CreatedDate, t.Description, t.Id, t.WhatId from Task t WHERE What.Type = 'accounts' limit 10
 
Similar function for events
 
Select What.Type, e.CreatedById, e.CreatedDate, e.Description, e.Id, e.WhatId from Event e WHERE What.Type = 'accounts' limit 10
 
Hope this helps.

Please mark it best answer if it helps.
Thanks
Rowallim TechnologyRowallim Technology
Hii App Development
 You can also do it from "Data management -> Data Export". this can be also done in Data loader.
 Thanks