Skip to main content
Topics#ApexDivaker singh 的问题
Divaker singh 提问于 #Apex
2015年1月24日 07:03

delete duplicate records

Hi,

I want to delete duplicate records. I am querying on sobject based on some condition to get duplicates. But I am unable to get which record has most number of fields filled among duplicates. Please provide suggestions.
2 个回答
  1. Pratik Mansukhlal Munot (Salesforce)
    2015年1月25日 09:16
    Hi Divaker,

    To find out the duplicate record, if you are comparing some field on records, so to find out which record has maximun information, compare the fields and maintain the score (a count which will increment if field is not blank and then et the end compare the count). As per the score delete the record which has less score. This is a approach which i think can be useful. You can add your inputs over it.

    Thanks,

    Pratik
撰写回答...
0/9000