I've got an Apex trigger that I'm attempting to bulkify to handle multiple records.  Essentially what I want to do is to update a custom Number field on my Campaign records, which is a count of a number of Lead records that have a particular status (Note: Lead Status, not Campaign Member status), any time a Lead record is updated.

I did a proof of concept for a single record, using the following trigger:

trigger leadTrigger1 on Lead(after insert, after update, after delete) { CampaignMember cm = [select CampaignId from CampaignMember where LeadId = :Trigger.new[0].Id limit 1]; Campaign c = [select Id, name, Wastage__c from Campaign where Id = :cm.CampaignId limit 1]; Integer count = [select count() from CampaignMember where CampaignId = :cm.CampaignId and Lead.Status = 'Closed - Not Converted']; System.Debug( 'count = ' + count ); c.Wastage__c = (Double)count; update(c); }

This works great for one record, but it doesn't take into consideration updates of multiple Lead records that are possibly associated with different campaigns.  I'm attempting to write something to the effect of:

trigger leadTrigger1 on Lead(after insert, after update, after delete) { System.Debug( 'leadTrigger1 fired!' ); Set<Id> leadIds = new Set<Id>(); for( Lead l : Trigger.old ) leadIds.add(l.Id); for( Lead l : Trigger.new ) leadIds.add(l.Id); CampaignMember [] cms = [select CampaignId from CampaignMember where LeadId in :leadIds]; Set<Id> cIds = new Set<Id>(); for( CampaignMember cm : cms ) cIds.add( cm.CampaignId ); Campaign [] cList = [select Id, name, Wastage__c from Campaign where Id in :cIds]; Map<Id, Integer> counts = new Map<Id, Integer> = Some SOQL query that will give me a map of Ids and the counts associated with those Ids. for( Campaign c : cList ) { c.Wastage__c = (Double)counts.get(c.Id); update(c); } }

But I'm not having any luck coming up with a SOQL query to give me a map of the Ids with the count.  Can this be done?  Any help would be greatly appreciated.

Thanks in advance,

Max

I have a fairly stright forward problem, but I'm not sure how I should solve it.  Basically, I need a new custom field on the Campaign table that is a count of the number of leads that have a particular status.  Unfortunately, I can't simply create a Roll-Up Summary field on Campaigns, because it's not the master in a master-detail relationship.  In other words, I need a field on Campaigns that is essentially a count of the number of leads associated with that campaign that have a particular status.  How should I approach this?

The one possibility that I can see is that I could add a trigger that fires on insert/update/delete of leads that performs the appropriate SOQL query and updates the associated Campaign record(s); however, this seems a bit round-about, and my have to be done for all Campaign records every time that a Lead record is updated.  Is there a better way to do this?

Thanks in advance,

Max

I'm looking to create several packages for distribution on the AppExchange.  I intend to create a base package with core features that will be used by my other packages.  This will allow users to select only the packages that contain the features that they want, rather than giving them one large package with functionality that they will never use.

My problem is that in trying to develop one of the package extensions, I can't find any way to say that it depends on the core package.  I see in the Package Summary that Extension is set to 'no'.  How do I change this so that I can reference global Apex classes defined in the core package?  I'm currently unable to reference these classes in my extension package.

Thanks in advance,

Max

I'm currently in the process of developing my first application for publication on the AppExchange, and I've come across a bit of a problem.  Originally, the application was designed to perform some lookups using information found on an Account Detail Page.  The problem is, that some of the potential users for this application store the information required for the lookup in custom fields rather than in the default Account record fiels (that the majority of users will use).

Is there any way that I can set up my package to allow the user to specify where to get the information for the lookup (preferably when they install the package)?  Or will I be forced to do something less user friendly, like setting up a configuration object that stores the actual field names that should be used for the lookup?

Any help would be greatly appreciated.

Thanks in advance,

Max

1. Create a new Outbound Message from Workflow
2. Generate the WSDL associated with the outbound message
3. Create a new web service on my server to handle the outbound message from Salesforce
4. This new web service must query Salesforce if there is any additional information that I need because the Outbound Message is limited to sending the fields on the table for which the event is defined.
5. Once I have this additional information I can then perform the actual web query that I wanted to perform from Salesforce, only now the response will come to my application.
6. Once I have the response I can update the record accordingly, either by defining an Apex web service or by generating a SOAP message as defined by the WSDL for my particular instance.

I've got an Apex trigger that I'm attempting to bulkify to handle multiple records.  Essentially what I want to do is to update a custom Number field on my Campaign records, which is a count of a number of Lead records that have a particular status (Note: Lead Status, not Campaign Member status), any time a Lead record is updated.

I did a proof of concept for a single record, using the following trigger:

trigger leadTrigger1 on Lead(after insert, after update, after delete) { CampaignMember cm = [select CampaignId from CampaignMember where LeadId = :Trigger.new[0].Id limit 1]; Campaign c = [select Id, name, Wastage__c from Campaign where Id = :cm.CampaignId limit 1]; Integer count = [select count() from CampaignMember where CampaignId = :cm.CampaignId and Lead.Status = 'Closed - Not Converted']; System.Debug( 'count = ' + count ); c.Wastage__c = (Double)count; update(c); }

This works great for one record, but it doesn't take into consideration updates of multiple Lead records that are possibly associated with different campaigns.  I'm attempting to write something to the effect of:

trigger leadTrigger1 on Lead(after insert, after update, after delete) { System.Debug( 'leadTrigger1 fired!' ); Set<Id> leadIds = new Set<Id>(); for( Lead l : Trigger.old ) leadIds.add(l.Id); for( Lead l : Trigger.new ) leadIds.add(l.Id); CampaignMember [] cms = [select CampaignId from CampaignMember where LeadId in :leadIds]; Set<Id> cIds = new Set<Id>(); for( CampaignMember cm : cms ) cIds.add( cm.CampaignId ); Campaign [] cList = [select Id, name, Wastage__c from Campaign where Id in :cIds]; Map<Id, Integer> counts = new Map<Id, Integer> = Some SOQL query that will give me a map of Ids and the counts associated with those Ids. for( Campaign c : cList ) { c.Wastage__c = (Double)counts.get(c.Id); update(c); } }

But I'm not having any luck coming up with a SOQL query to give me a map of the Ids with the count.  Can this be done?  Any help would be greatly appreciated.

Thanks in advance,

Max

I have a fairly stright forward problem, but I'm not sure how I should solve it.  Basically, I need a new custom field on the Campaign table that is a count of the number of leads that have a particular status.  Unfortunately, I can't simply create a Roll-Up Summary field on Campaigns, because it's not the master in a master-detail relationship.  In other words, I need a field on Campaigns that is essentially a count of the number of leads associated with that campaign that have a particular status.  How should I approach this?

The one possibility that I can see is that I could add a trigger that fires on insert/update/delete of leads that performs the appropriate SOQL query and updates the associated Campaign record(s); however, this seems a bit round-about, and my have to be done for all Campaign records every time that a Lead record is updated.  Is there a better way to do this?

Thanks in advance,

Max

I'm looking to create several packages for distribution on the AppExchange.  I intend to create a base package with core features that will be used by my other packages.  This will allow users to select only the packages that contain the features that they want, rather than giving them one large package with functionality that they will never use.

My problem is that in trying to develop one of the package extensions, I can't find any way to say that it depends on the core package.  I see in the Package Summary that Extension is set to 'no'.  How do I change this so that I can reference global Apex classes defined in the core package?  I'm currently unable to reference these classes in my extension package.

Thanks in advance,

Max

1. Create a new Outbound Message from Workflow
2. Generate the WSDL associated with the outbound message
3. Create a new web service on my server to handle the outbound message from Salesforce
4. This new web service must query Salesforce if there is any additional information that I need because the Outbound Message is limited to sending the fields on the table for which the event is defined.
5. Once I have this additional information I can then perform the actual web query that I wanted to perform from Salesforce, only now the response will come to my application.
6. Once I have the response I can update the record accordingly, either by defining an Apex web service or by generating a SOAP message as defined by the WSDL for my particular instance.