This is an excerpt of code running in an After Update query:

    
Set<Id> setOpptsToDelete = new Set<Id>();    	

// Loop through the Opportunities being updated or deleted and see if there are any for the record types we want. 

if(trigger.isDelete){
    for (Opportunity o : Trigger.old)	{ 	
      If (s.contains(o.RecordTypeId)){          
             	setOpptsToDelete.add(o.Id);
      }     	   
   }  		
}        

List<AdvisorGAS_Production__c> listAdvisorGasDelete = new List<AdvisorGAS_Production__c>();	

for (AdvisorGAS_Production__c agpDelete : [Select Id from AdvisorGAS_Production__c where Opportunity__c in :setOpptsToDelete]) {
        listAdvisorGasDelete.add(agpDelete);
    }	

The query in red returns nothing yet when I manually query against the specific Opportunity Id (ie: Select Id from AdvisorGAS_Production__c where Opportunity__c = '0068000000X2fFg'), I get a value.

I can't figure out why it's not returning anything.  Here's some debug data I've set up and am getting:

USER_DEBUG|[51,5]|DEBUG|#### Trigger is delete. setOpptsToDelete.size = 1

|SOQL_EXECUTE_BEGIN|[98,47]|Aggregations: 0 |Select Id from AdvisorGAS_Production__c where Opportunity__c in :setOpptsToDelete

USER_DEBUG|[158,2]|DEBUG|###      listAdvisorGasDelete.size = 0

I have a trigger that needs to filter only the records affected that fall into a certain Record Type.  In the past I've made multiple calls to get some variables for the record types I want to use and then use if statements, but that is a poor use of resources.  I'd rather just pull those record types into a list or set so that I could match for a value in a set when looping.

Here's what I'd like to do:

// Create a list of RecordTypes we want to check for
List<RecordType> rtID = [SELECT Id FROM RecordType WHERE (SobjectType = 'Opportunity') AND (Name = 'Annuity' OR Name = 'Life' OR Name='LTC' OR Name = 'TLC')]; 

// Create a list for Opportunities that match our RecordType criteria
List<Opportunity> opptsToWorkOn = new List<Opportunity>();

// Loop through the Opportunities being updated or deleted and see if there are any 
// for the record types we want.  
if(trigger.isDelete){
    for (Opportunity o : Trigger.old)	{
    
    \\ #### HERE IS WHAT DOESN'T WORK ": rtID" - Does anyone know how to do this?
    If (o.RecordTypeId = : rtID) 		     
      	   opptsToWorkOn.add(o);	
      } 
    }
    else{
      for (Opportunity o : Trigger.new) {
    \\ #### I WOULD ALSO DO IT HERE! #########
    If (o.RecordTypeId = : rtID)        
           opptsToWorkOn.add(o);	
      } 
    }

Can someone point me in the right direction?

Thanks!

Greg

    \\ #### HERE IS WHAT DOESN'T WORK ": rtID" - Does anyone know how to do this?

Working on a trigger that creates a new opportunity when a particular type of opportunity is Closed Won.  I can't clone it because a number of things change, but for creating the new opportunity I need to be able to get at the values of not only the opportunity but the product line items.

There are two things I'm not sure of:

1) Are the product line items included via the Opportunity when I create a map of Opportunities?  If so, how do I reference them later when extracting certain values to apply to the new Opportunity?

2) How do I create the line items for the new opportunity?

Here's the code I have so far excluding the items referenced above:

trigger createRepSitesRecurringOpportunity on Opportunity (after insert, after update) { RecordType rt = [SELECT Id FROM RecordType WHERE Name = 'Rep Sites' AND SobjectType = 'Opportunity']; // Create map for Contact ID's & Opportunities, that match our RecordType criteria Map<Id,Opportunity> mapRepSitesOpportunities = new Map<Id, Opportunity>(); // Loop through the Opportunities being inserted and see if there are any for the Rep Sites record type and "Apply Recurring Billing = true". for (Opportunity o : trigger.new) { If ((o.RecordTypeId == rt.Id) && (o.Apply_Recurring_Billing__c == true)){ mapRepSitesOpportunities.put(o.Contact__c, o); } } system.debug('mapRepSitesOpportunities.size at Line 15 = ' + mapRepSitesOpportunities.size()); If (mapRepSitesOpportunities.size() > 0) { //Check for Rep Sites = Active and remove Opportunities from the list where Rep is no longer active. List<Id> contactidsForOpptToNotCreate = new List<Id>(); for (Contact c : [Select Id, Rep_Sites__c from Contact where Id in :mapRepSitesOpportunities.keySet()]) { If (c.Rep_Sites__c <> 'Active') { mapRepSitesOpportunities.remove(c.Id); } } } system.debug('mapRepSitesOpportunities.size at Line 29 = ' + mapRepSitesOpportunities.size()); //Create Oppt with the correct Recurring product/amount and set the Close Date to First Day of the next month If (mapRepSitesOpportunities.size() > 0) { List<Opportunity> opptsToInsert = new List<Opportunity>(); Opportunity newOppt = new Opportunity(); for(Opportunity oppt : [Select RecordTypeId, Name, Contact__c, AccountId, Amount From Opportunity where Id in :mapRepSitesOpportunities.values()]) { newOppt.Name = oppt.Name + ' Recurring Auto Generated'; newOppt.AccountId = oppt.AccountId; newOppt.Contact__c = oppt.Contact__c; newOppt.RecordTypeId = oppt.RecordTypeId; newOppt.CloseDate = Date.today(); //change this to first of next month newOppt.Amount = oppt.Amount; //stop mapping this once the product is created and amount set there. newOppt.StageName = 'Recurring Billing'; opptsToInsert.add(newOppt); } insert(opptsToInsert); } }

I have the following query that works just like I want it:

Select a.Status__c, a.Notes__c, a.Id, a.Contracted_As__c, a.Confirm_Date__c, a.Commission_Level__c, a.Agent__c, a.Account__c From Appointment__c a WHERE Status__c = 'Active' AND RecordTypeId = '012400000005AKK'

except, instead of the Account ID (which is what is returned by a.Account__c), I want the account name.  I've tried looking through the SOQL  docs for relationship querries, I've tried Apex Explorer and Eclipse, but I can't seem to get it right.

Here's what I came up with in Apex Explorer except none of the Appointment__c fields are returned, just the account name, and I can't figure out how to put the where clause relating to items in the custom object:

Select a.Name, (Select Agent__c, Commission_Level__c, Confirm_Date__c, Contracted_As__c, Id, Notes__c, Status__c From Appointments__r) from Account a

Can someone point me in the right direction?

I've got everything configured and created for this Tutorial.

However, when I run it, including the included test app -- (and based on the docs it appears I should be able to run this from my local computer) -- 
the Outbound Messaging Sample Tester prompts me for my SalesForce credentials.  I type them in -- using my Developer License login (and security token), which is where I created the Outbound Message wsd, but it won't accept my credentials.

Do I need to turn something on in my developer org to accept these calls?

This is an excerpt of code running in an After Update query:

    
Set<Id> setOpptsToDelete = new Set<Id>();    	

// Loop through the Opportunities being updated or deleted and see if there are any for the record types we want. 

if(trigger.isDelete){
    for (Opportunity o : Trigger.old)	{ 	
      If (s.contains(o.RecordTypeId)){          
             	setOpptsToDelete.add(o.Id);
      }     	   
   }  		
}        

List<AdvisorGAS_Production__c> listAdvisorGasDelete = new List<AdvisorGAS_Production__c>();	

for (AdvisorGAS_Production__c agpDelete : [Select Id from AdvisorGAS_Production__c where Opportunity__c in :setOpptsToDelete]) {
        listAdvisorGasDelete.add(agpDelete);
    }	

The query in red returns nothing yet when I manually query against the specific Opportunity Id (ie: Select Id from AdvisorGAS_Production__c where Opportunity__c = '0068000000X2fFg'), I get a value.

I can't figure out why it's not returning anything.  Here's some debug data I've set up and am getting:

USER_DEBUG|[51,5]|DEBUG|#### Trigger is delete. setOpptsToDelete.size = 1

|SOQL_EXECUTE_BEGIN|[98,47]|Aggregations: 0 |Select Id from AdvisorGAS_Production__c where Opportunity__c in :setOpptsToDelete

USER_DEBUG|[158,2]|DEBUG|###      listAdvisorGasDelete.size = 0

I have a trigger that needs to filter only the records affected that fall into a certain Record Type.  In the past I've made multiple calls to get some variables for the record types I want to use and then use if statements, but that is a poor use of resources.  I'd rather just pull those record types into a list or set so that I could match for a value in a set when looping.

Here's what I'd like to do:

// Create a list of RecordTypes we want to check for
List<RecordType> rtID = [SELECT Id FROM RecordType WHERE (SobjectType = 'Opportunity') AND (Name = 'Annuity' OR Name = 'Life' OR Name='LTC' OR Name = 'TLC')]; 

// Create a list for Opportunities that match our RecordType criteria
List<Opportunity> opptsToWorkOn = new List<Opportunity>();

// Loop through the Opportunities being updated or deleted and see if there are any 
// for the record types we want.  
if(trigger.isDelete){
    for (Opportunity o : Trigger.old)	{
    
    \\ #### HERE IS WHAT DOESN'T WORK ": rtID" - Does anyone know how to do this?
    If (o.RecordTypeId = : rtID) 		     
      	   opptsToWorkOn.add(o);	
      } 
    }
    else{
      for (Opportunity o : Trigger.new) {
    \\ #### I WOULD ALSO DO IT HERE! #########
    If (o.RecordTypeId = : rtID)        
           opptsToWorkOn.add(o);	
      } 
    }

Can someone point me in the right direction?

Thanks!

Greg

    \\ #### HERE IS WHAT DOESN'T WORK ": rtID" - Does anyone know how to do this?

Working on a trigger that creates a new opportunity when a particular type of opportunity is Closed Won.  I can't clone it because a number of things change, but for creating the new opportunity I need to be able to get at the values of not only the opportunity but the product line items.

There are two things I'm not sure of:

1) Are the product line items included via the Opportunity when I create a map of Opportunities?  If so, how do I reference them later when extracting certain values to apply to the new Opportunity?

2) How do I create the line items for the new opportunity?

Here's the code I have so far excluding the items referenced above:

trigger createRepSitesRecurringOpportunity on Opportunity (after insert, after update) { RecordType rt = [SELECT Id FROM RecordType WHERE Name = 'Rep Sites' AND SobjectType = 'Opportunity']; // Create map for Contact ID's & Opportunities, that match our RecordType criteria Map<Id,Opportunity> mapRepSitesOpportunities = new Map<Id, Opportunity>(); // Loop through the Opportunities being inserted and see if there are any for the Rep Sites record type and "Apply Recurring Billing = true". for (Opportunity o : trigger.new) { If ((o.RecordTypeId == rt.Id) && (o.Apply_Recurring_Billing__c == true)){ mapRepSitesOpportunities.put(o.Contact__c, o); } } system.debug('mapRepSitesOpportunities.size at Line 15 = ' + mapRepSitesOpportunities.size()); If (mapRepSitesOpportunities.size() > 0) { //Check for Rep Sites = Active and remove Opportunities from the list where Rep is no longer active. List<Id> contactidsForOpptToNotCreate = new List<Id>(); for (Contact c : [Select Id, Rep_Sites__c from Contact where Id in :mapRepSitesOpportunities.keySet()]) { If (c.Rep_Sites__c <> 'Active') { mapRepSitesOpportunities.remove(c.Id); } } } system.debug('mapRepSitesOpportunities.size at Line 29 = ' + mapRepSitesOpportunities.size()); //Create Oppt with the correct Recurring product/amount and set the Close Date to First Day of the next month If (mapRepSitesOpportunities.size() > 0) { List<Opportunity> opptsToInsert = new List<Opportunity>(); Opportunity newOppt = new Opportunity(); for(Opportunity oppt : [Select RecordTypeId, Name, Contact__c, AccountId, Amount From Opportunity where Id in :mapRepSitesOpportunities.values()]) { newOppt.Name = oppt.Name + ' Recurring Auto Generated'; newOppt.AccountId = oppt.AccountId; newOppt.Contact__c = oppt.Contact__c; newOppt.RecordTypeId = oppt.RecordTypeId; newOppt.CloseDate = Date.today(); //change this to first of next month newOppt.Amount = oppt.Amount; //stop mapping this once the product is created and amount set there. newOppt.StageName = 'Recurring Billing'; opptsToInsert.add(newOppt); } insert(opptsToInsert); } }

Hi!

I've created a trigger to create a task everytime someone creates an Opportunity's product. But I have a problem, the trigger creates the task twice! I couldn't find yet the problem. Could someone tell what's wrong in the code?

Thanks! :smileyhappy:

trigger createTask2 on OpportunityLineItem (before insert, before update) {

    List<Task> tasks = new List<Task>();
    List<OpportunityLineItem> OppLIs = Trigger.new;
    
    for (OpportunityLineItem OppLI : OppLIs) {
        
        //Obtengo el Id del usuario que creo la oportunidad
        Opportunity Opp = [ Select OwnerId from Opportunity where id=:OppLI.OpportunityId limit 1 ];
        
        //User usuario = [ Select Name from ]

        //Obtengo el día que se vence el producto
        Date diaVenc = OppLI.Fecha_de_vencimiento__c;
        Datetime dhReminder = datetime.newInstance(diaVenc.year(), diaVenc.month(),diaVenc.day());
        dhReminder.addHours(10);



        Task tsk = new Task(whatID = OppLI.OpportunityId, 
                            Ownerid = Opp.OwnerId, 
                            Subject = 'test', 
                            ActivityDate = diaVenc,
                            IsReminderSet = true,
                            ReminderDateTime = dhReminder );
        tasks.add(tsk);
        
    }
    
    insert tasks;
}