Apex Code Development You need to sign in to do that
Don't have an account?
Write a Batch class to delete Campaign Member
I need to write a Batch class for Campaign members delete. I need to find the campaign member with a relationship with contact/lead associated with Campaign with Completed/Aborted status.
Can i make it with a single query? How can i manage the complex query with Batch class? Thank you for your support
Can i make it with a single query? How can i manage the complex query with Batch class? Thank you for your support
Please find the updated query:
SELECT Id,LeadId,ContactId FROM CampaignMember where (Campaign.Status='Completed' OR Campaign.Status='Aborted') AND (LeadId != Null OR ContactId != Null)
Batch Class:
global class deleteCampaignMembers implements Database.Batchable<sObject>
{
global Database.QueryLocator start(Database.BatchableContext BC)
{
return Database.getQueryLocator('SELECT Id,LeadId,ContactId FROM CampaignMember where (Campaign.Status='Completed' OR Campaign.Status='Aborted') AND (LeadId != Null OR ContactId != Null)');
}
global void execute(Database.BatchableContext BC,List<CampaignMember> scope)
{
Delete scope;
}
global void finish(Database.BatchableContext BC)
{
}
}
Schedule Class:
global class deleteCampaignMembersScheduable implements Schedulable
{
global void execute(SchedulableContext ctx)
{
id batchinstanceid = database.executeBatch(new deleteCampaignMembers());
}
}
Can you please Let me know if it helps or not!!!
If it helps don't forget to mark this as a best answer!!!
Thanks,
Raj
All Answers
Batch
global class BatchAddToCampaign implements Database.Batchable<sObject>, Database.Stateful { global Database.QueryLocator start(Database.BatchableContext BC) { return Database.getQueryLocator([Select Id ,ContactId , LeadId from CampaignMember where Campaign.Status='Completed' OR Campaign.Status='Aborted' OR ContactId !=NULL OR LEADID!=NULL]); } global void execute(Database.BatchableContext BC, List<Sobject> scope) { delete scope ; } global void finish(Database.BatchableContext BC) { } }Please find the updated query:
SELECT Id,LeadId,ContactId FROM CampaignMember where (Campaign.Status='Completed' OR Campaign.Status='Aborted') AND (LeadId != Null OR ContactId != Null)
Batch Class:
global class deleteCampaignMembers implements Database.Batchable<sObject>
{
global Database.QueryLocator start(Database.BatchableContext BC)
{
return Database.getQueryLocator('SELECT Id,LeadId,ContactId FROM CampaignMember where (Campaign.Status='Completed' OR Campaign.Status='Aborted') AND (LeadId != Null OR ContactId != Null)');
}
global void execute(Database.BatchableContext BC,List<CampaignMember> scope)
{
Delete scope;
}
global void finish(Database.BatchableContext BC)
{
}
}
Schedule Class:
global class deleteCampaignMembersScheduable implements Schedulable
{
global void execute(SchedulableContext ctx)
{
id batchinstanceid = database.executeBatch(new deleteCampaignMembers());
}
}
Can you please Let me know if it helps or not!!!
If it helps don't forget to mark this as a best answer!!!
Thanks,
Raj