Problem with Merge Statement?

Question

I am trying to merge two lead records, please find below the code.

Lead leads = [SELECT Email,company,RFI_Record_Type__c FROM Lead WHERE email IN:emailSet and Email !=null and Id not IN:leadIds Order By CreatedDate DESC Limit 1];

List<Lead> newLeads = [SELECT Email,company,RFI_Record_Type__c FROM Lead WHERE Id IN:leadIds and Email != null];

merge leads newleads;

leads is the master record and newLeads is the duplicate/new records. Both the SOQL queries return a row, which is good. When I debug, it shows both are merged and the merged record deleted which is good.

But When I again try to assert for the merged value by using a soql over leads as same as the first SOQL above, it returns the same old record but does not display any merged value.

If we merge a merged record with master record , then will all the fields on the merged record get copied into the master record ?

Any help would be nice to have.

Thank You

Answer 1

I believe your problem is simply that you need to query back for Leads to assert on.

Answer 2

I found my answer .

I can have something like.

leads.RFI_Record_Type__c=newLeads[0].RFI_Record_Type__c;

So, it updates the existing master record and deletes the merged record.

Thanks everyone for the help.

Answer 3

I do not have lot of knowledge on the subject of merging, but seeing as no one has answered yet, I want to throw in my two cents.

On the Merge Statement Documentation Page it states that you can either pass one or two sObjects to the merge statement as the second parameter. If you are passing two objects, you should do so in a list (as you are doing - which is good).

merge sObject sObject;
merge sObject sObject[];

What might be catching you here is that you can only merge one or two records into one record. Since I can't see what your list look like, all I can do is suggest that you ensure that at most two records are being populated into your newLeads list.

A couple of questions that you should investigate:

1. Is newLeads always one or two records?
2. Do you have a few similar leads in emailSet that you may be incorrectly recognizing as the same lead?
3. Are you ensuring that your assert statement is querying fresh results for the modified lead?