You need to sign in to do that
Don't have an account?
meet.siva
How to prevent duplicates from inserting?
Hi,
I have to insert unique records(i.e remove the duplicates) from some custom field (say employee_id) in one custom object into another custom field in another custom object.
Can anyone share some working code? It will be helpful.
Regards,
S.Sivakumar.
http://www.salesforce.com/docs/developer/cookbook/Content/apex_dedupe.htm
Hey thanks.
I had gone through it already. But i am not able to get unique records from one custom object and insert into another custom object. So can u help me with some code.
Regards,
S.Sivakumar
There are several ways to get a distinct collection. You could use an AggregateResult SOQL query; if its a relatively modest amount of results, you could query for the full list then manually sort them yourself in Apex, maybe put them in a Set:
Set <ID> uniqueIDs = new Set <ID> ();
for (Obj_A__c nextObj : [Select employee_id From Obj_A__c]) {
uniqueIDs.add(Obj_A__c.employee_id);
}
for (ID nextID : uniqueIDs) {
// do something with Obj_B__c
}
Aggregate queries have been covered in many threads, governor limits can be an issue if you are talking about 50k+ results:
http://boards.developerforce.com/t5/Apex-Code-Development/SELECT-DISTINCT-equivalent-in-SOQL/td-p/261019