You need to sign in to do that
Don't have an account?
Sangeetha 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
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
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.