You need to sign in to do that
Don't have an account?
Andrew Morales 1
SOQL Query Question - Select Specific ID's
Hello.
I would like to write a SOQL query in Data Loader that would include a list of 100 specific Contact record ID's to export (only) those records.
This is as close as I came but it is not returning the expected results.
SELECT Id,
FROM Contact
WHERE ID IN ('a4fa0000000KzbV','a4fa0000000KzbW',...........)
Any help would be greatly appreciated.
I would like to write a SOQL query in Data Loader that would include a list of 100 specific Contact record ID's to export (only) those records.
This is as close as I came but it is not returning the expected results.
SELECT Id,
FROM Contact
WHERE ID IN ('a4fa0000000KzbV','a4fa0000000KzbW',...........)
Any help would be greatly appreciated.
2. Yes, you could include a list of email addresses to get all contacts that have one of the email addresses. One thing to note is that multiple contacts can have the same email adress.
This
SELECT Id,
FROM Contact
WHERE ID IN ('a4fa0000000KzbV','a4fa0000000KzbW',...........) way will help you to get specific 100 records but this might increase your work as you have to put all 100 contact ids in condition instead of that you can use some other field that matched only these 100 contacts.