function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Satish RamananSatish Ramanan 

Finding duplicates on the basis of First Name and Last Name

Hi, I want to get the list of all the duplicates in the SF on the basis of First Name and Last Name. I don't have that much time to go into the detail page of each and every record and find duplicates by clicking "Find Duplicates" button. Is this possible by any other way to just click a button and get all the list in one shot?

 

Thanks.

Cloud CredenceCloud Credence

Hi,

 

Since your criteria for finding duplicates is relatively simple, you can write an apex class that generates and displays this information in a VF page, subject to governor limits.

 

Or you should consider using AppExchange solutions specializing in de-duplication.

 

Thanks,

 

 
Raj10202Raj10202

Hi Satish,

 

Create a report with a 3 field filters on contact object. The field filter should take the parameter values as record id, first name and last name. The record id should not match with the current record id. 

 

The record id parameter should take the condition as 'not equal to'.

 

Invoke this report using the custom button/link on the contact detail page...it will give you the other records with duplicate names.

 

Create a custom button with below code then

 

../<report_id>?pv0={!Contact.Id}&pv1={!Contact.LastName}&pv2={!Contact.FirstName}

 

Regards,

Raj