+ Start a Discussion
Sangeetha TSangeetha T 

out of box functionality to extract 56K records field when you have their name

Exporting more 50K record information - Out of Box functionality
Hi 

I have 56K records name in hand, I need to export their repective Record ID and other fields. If I form the SOQL query like the following I will result in QUERY size limit exceeding 20K characters 
 
SELECT ID,Name from Object__c "WHERE Name IN ('dd',dd',..................) 

Optimizing the IN with batch by batch records is tidious 

Any better out of box functionality to extract 56K records field when you have their name

Thanks in advance 
SANGEETHA T
Zoran IlievskiZoran Ilievski
I have run into this problem before with different fields.

My solution has been to export all records with the fields you need, in your case `Id` and `Name` from your Object.
Or use a filter to narrow down the export size, but you need to make sure it contains all the records you need.

Then in Excel you can use the COUNTIF or VLOOKUP function to determine which records are present from one file in the other.

Hope this helps.