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
mohammadd ismailmohammadd ismail 

Exporting data from certain users

How can we export data from particular users using data loader.

Thanks in advance
Best Answer chosen by mohammadd ismail
NagendraNagendra (Salesforce Developers) 
Hi Ismail,

First grab the users id that you want to export, then for example if you want to export data from Account then use this query
 
select id,ownerid from Account where ownerid in('00587jhhjh79hjj','00578nhg8hujj'.....), this should get u the records from account.

Kindly mark this as the best answer if it helps you.

Best Regards,
Nagendra.P

 

All Answers

Siddharth83JainSiddharth83Jain
Hi Ismail,

Do you mean to extract all the data for just 1 user. If that is the case, then based on your criteria you need to add a filter in your query based on either OWNERID, CREATEDBYID or LASTMODIFIEDBYID. This way you can limit the data owned or managed by that user.

Please mark this as best answer if it helps.

Thanks
Siddharth
OSI Consulting.
Amit Chaudhary 8Amit Chaudhary 8
Hi,

If you can add the filter or limit in your query
https://help.salesforce.com/apex/HTViewSolution?id=000193791&language=en_US
suppose you want to extract any 5 record then

LIMIT
Select id,username,email from user limit 5
Filter
Select id,username,email from user where username like '%amit%'
For all active user
Select id,username,email from user where isActive = true
Let us know if this will help you


 
NagendraNagendra (Salesforce Developers) 
Hi Ismail,

First grab the users id that you want to export, then for example if you want to export data from Account then use this query
 
select id,ownerid from Account where ownerid in('00587jhhjh79hjj','00578nhg8hujj'.....), this should get u the records from account.

Kindly mark this as the best answer if it helps you.

Best Regards,
Nagendra.P

 
This was selected as the best answer