You need to sign in to do that
Don't have an account?
Need help with SOQL query in workbench
Hi I am trying to extract the contacts with accounts where the clean mobile numbers are following (there are some 100 clean mobile numbers I have in hand) eg. 999999999,777777777..so on. Bascically I need to fetch those contact ids with their account ids.
The query I am working is like:
The query I am working is like:
SELECTAccountId,Account_Number__c,Clean_Mobile_Number__c,Clean_Phone_Number__c,Company__c,Contact_ID__c,FirstName,Id,LastName,Name FROM Contact WHERE Clean_Mobile_Number__c IN (999999999,777777777...)What is the best way to write this query? Thank you, Mit



Is it fine too use Apex Execute for this under utilities?