I have an interesting request:
We sold a region to another company, and we'd like to give the departing salespeople their data. It's a simple query to get everything the 4 users from that region created or own by userid.
The request is, "Get every account, contact, etc. that they had an activity on" for export.
Tooling-wise, I've got the excel add-in and Jitterbit dataloader, which is very cool.
I know how to do this in apex (relationship query up related records on activity) but I'm not sure how to go from that to CSV. Advice?