trigger Opportunity_NewBUBD on Opportunity (after insert, after update) { for (Opportunity o : Trigger.new) { if (trigger.isUpdate) { for (Integer i = 0; i < Trigger.old.size(); i++) { if (trigger.Old[i].BU_Business_Development__c != Null) { if (trigger.Old[i].BU_Business_Development__c != o.BU_Business_Development__c) { OpportunityContactRole [] oDWs = [select id from OpportunityContactRole where OpportunityId = :trigger.old[i].id and ContactId=:trigger.old[i].BU_Business_Development__c and Role = 'BU Business Development']; delete oDWs; } } Integer oDWs1 = [select count() from OpportunityContactRole where OpportunityId = :trigger.old[i].id and ContactId =:trigger.new[i].BU_Business_Development__c and Role = 'BU Business Development']; if (oDWs1 == 0 & o.BU_Business_Development__c != Null) { OpportunityContactRole OCR1 = new OpportunityContactRole (OpportunityId=o.id, ContactId =o.BU_Business_Development__c, Role = 'BU Business Development'); insert OCR1; } } } if (trigger.isInsert) { if (o.BU_Business_Development__c != Null) { OpportunityContactRole OCR1 = new OpportunityContactRole (OpportunityId=o.id, ContactId = o.BU_Business_Development__c, Role = 'BU Business Development'); insert OCR1; } } } }

1. I would be very grateful on your views of the design of the apexcode?
2. I believe that some of this code should be called using a function to facility the reuse of the code; can you provide some suggestions on this? (i.e. rows 26-30 and 38-42)
3.  I would like to use dynamic code utilising an array of fields that should be ‘monitored’ so that one piece of code can be used to populate the OpportunityContactRole for many fields.  (This would need to have a variable for the Role and the fieldname.) Any ideas?

Hello,

We have added a field "Assign to" on Case (a lookup on user) to let Salesforce.com users the ability to change the owner of a case from the case list. The Case owner is then updated via a trigger (before update on case) that is copying the "Assign to" field value into the Case.owner field.

The trigger works fine and the case owner is updated correctly.

The issue is that when the case owner is updated via that procedure, an automatic email is sent to the new Case owner to warn him that he s now assigned to the case. We do NOT want this email to be sent.

How can we prevent that email to be sent? Is there a piece of code available for that?

Here is the code I'm using currently:

trigger AssignToCaseOwner on Case (before update) {
	Integer i = 0;
	for(Case theCase : System.Trigger.new)
	{
		// only executed if the case owner is not changed as well 
		// and if the case owner is not already the "Assign to" user
		if(theCase.OwnerId == System.Trigger.old.get(i).OwnerId && 
			theCase.Assign_to__c != null && 
			theCase.Assign_to__c != System.Trigger.old.get(i).Assign_to__c && 
			theCase.OwnerId != theCase.Assign_to__c)
		{
			theCase.OwnerId = theCase.Assign_to__c;
			// set DML options to remove the auto email -> NOT WORKING
			Database.DMLOptions dlo = new Database.DMLOptions();
			dlo.EmailHeader.triggerUserEmail = false;
			theCase.setOptions(dlo);
		}
		
		// Make the "Assign to" field empty as we do not need the value 
		// to be stored in the record
		theCase.Assign_to__c = null;
	
		i++;
	}
}

Thanks on beforehand,
Martin HUBERT.

I have a simple trigger on Leads that needs to know if the Owner is a User or a Queue.

Can anyone show me the (proably very) simple solution to this? My code is below, with the 'real world' question if Owner = Queue.

 Set<id> ownerIds = new Set<id>();
    for (Lead l : Trigger.new)
        ownerIds.add(l.OwnerId);
        
    Map<id, User> owners = new Map<id, User>([Select Id from User Where Id in :ownerIds]);      
    
    for (Lead l : Trigger.new)
        if(l.Owner = queue){
        //l.Owner_Usable__c = null;
        } else {
        //l.Owner_Usable__c  = owners.get(l.OwnerId).Id;
        }

Hi I have code that successfully clones the opportunity related list for opportunity partner.  Now that we have included products for the opportunity I see a new button that has a little picklist option arrow on it.  This is built in and allows cloning the opportunity by itself or with the products. 

This is an issue for my custom cloning button that was cloning the opportunity with related partner record(s)!

I posted that code at: http://boards.developerforce.com/t5/Apex-Code-Development/Code-behind-the-Clone-Button/m-p/201476#M34627

Does anyone have code that clones the related products for a given opportunity?  I need to override the default clone button or hide it and use my own and figure out how to incorporate my code and the products cloning code so that all records successfully save or roll-back.

Does anyone have cloning code for products or another related list likeattachments, activities etc?  Products is on the plate now but I can see the future where users want to clone more related data!!!

trigger Opportunity_NewBUBD on Opportunity (after insert, after update) { for (Opportunity o : Trigger.new) { if (trigger.isUpdate) { for (Integer i = 0; i < Trigger.old.size(); i++) { if (trigger.Old[i].BU_Business_Development__c != Null) { if (trigger.Old[i].BU_Business_Development__c != o.BU_Business_Development__c) { OpportunityContactRole [] oDWs = [select id from OpportunityContactRole where OpportunityId = :trigger.old[i].id and ContactId=:trigger.old[i].BU_Business_Development__c and Role = 'BU Business Development']; delete oDWs; } } Integer oDWs1 = [select count() from OpportunityContactRole where OpportunityId = :trigger.old[i].id and ContactId =:trigger.new[i].BU_Business_Development__c and Role = 'BU Business Development']; if (oDWs1 == 0 & o.BU_Business_Development__c != Null) { OpportunityContactRole OCR1 = new OpportunityContactRole (OpportunityId=o.id, ContactId =o.BU_Business_Development__c, Role = 'BU Business Development'); insert OCR1; } } } if (trigger.isInsert) { if (o.BU_Business_Development__c != Null) { OpportunityContactRole OCR1 = new OpportunityContactRole (OpportunityId=o.id, ContactId = o.BU_Business_Development__c, Role = 'BU Business Development'); insert OCR1; } } } }

1. I would be very grateful on your views of the design of the apexcode?
2. I believe that some of this code should be called using a function to facility the reuse of the code; can you provide some suggestions on this? (i.e. rows 26-30 and 38-42)
3.  I would like to use dynamic code utilising an array of fields that should be ‘monitored’ so that one piece of code can be used to populate the OpportunityContactRole for many fields.  (This would need to have a variable for the Role and the fieldname.) Any ideas?