Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ckellieckellie 

How to add coditions to when my apex code inserts a record.

Below is my for loop to insert records:

 

     
       List<Customer_Product_Summary__c> cslist = new List<Customer_Product_Summary__c>([select id, customer_Product_catalog__c,Primary_Condition__c, account__c from Customer_Product_Summary__c where account__c =: o.accountid]);
     
   for(cCustomer p : getsummary())
   {
        system.debug('@@@@@@@$$$$$:'+p);  

      Customer_Product_Summary__c cs = new Customer_Product_Summary__c();
    
    cs.Account__c = o.accountid;
    cs.Customer_Product_Catalog__c = p.con.id;
    cs.name = p.con.name;  
    cs.Primary_Condition__c = p.con.Condition_1__c;
    cs.Primary_Shape__c = p.con.Shape_1__c;
    cs.Defect_Description__c = p.con.Defect_Description__c;
    cs.Capacity__c = p.con.Capacity__c;
    cs.Bulk_Density__c = p.con.Bulk_Density__c;
    cs.Industry_Segment__c = p.con.Industry_Segment__c;

    If(cs.Customer_Product_Catalog__c!=null){
      try {
      item1.add(cs);
 system.debug('#######################'+cs);
      } catch(System.DMLException e) {
        ApexPages.addMessages(e);

      }    
     }

 

Add the condition to only create the record if cs.Customer_Product_Catalog__c contains a unique value when the record is added to the list 'cslist'?

Thanks

 

Best Answer chosen by Admin (Salesforce Developers) 
liron169liron169

Hello,

 

1.By the way I wrote it the Set contains String - only the field Customer_Product_Catalog.

2.If your uniquness is combination of the 3 fields than add to the set the containation of them:
    cusPro_Set.add(p.con.id + p.con.Condition_1__c  + p.con.industry_segment__c);

If each of this field must be uniqe, then create 3 set and for each set add the relevant field.
inqSet1.add(p.con.id);
inqSet2.add(p.con.Condition_1__c);
inqSet3.add(p.con.industry_segment__c);

All Answers

liron169liron169

hi,

 

I'm not sure I clearly understand.

If the target is to insert only if the Customer_Product_Catalog is not exists yet in privoues records, then:

1.Collect all the existsing values:


Set<String> cusPro_Set=new Set<String>();
for(Customer_Product_Summary__c cps : cslist)
    cusPro_Set.add(cps.customer_Product_catalog__c);

2.Later when creating the new Customer_Product_Summary__c, use:


if(cusPro_Set.contains(p.con.id)
    continue
else{
    cusPro_Set.add(p.con.id);
    //do the insertion
}
ckellieckellie

I think you understand. When I add the cps.customer_Product_catalog__c to the set, am I only adding that one field or the entire record. For example can I expand the code in item 2 to the following?

 


if(cusPro_Set.contains(p.con.id) and custPro_Set.contains(p.con.Condition_1__c) and CustPro_set.contains(p.con.industry_segment__c))
    continue
else{
    cusPro_Set.add(p.con.id);
    //do the insertion
}

 

By the end of the code, I am wanting to only create unique records based on 3 separate fields (an id [p.con.id]  and two picklist fields [p.con.condition_1__c and p.con.industry_segment__c]).

 

Thanks
liron169liron169

Hello,

 

1.By the way I wrote it the Set contains String - only the field Customer_Product_Catalog.

2.If your uniquness is combination of the 3 fields than add to the set the containation of them:
    cusPro_Set.add(p.con.id + p.con.Condition_1__c  + p.con.industry_segment__c);

If each of this field must be uniqe, then create 3 set and for each set add the relevant field.
inqSet1.add(p.con.id);
inqSet2.add(p.con.Condition_1__c);
inqSet3.add(p.con.industry_segment__c);

This was selected as the best answer
ckellieckellie
This is great. and solved my problem. Thank you