You need to sign in to do that
Don't have an account?
marchandoj
SOQL Query on Campaign Members and their related leads
I'm trying to write an SOQL query which will return the list of campaign members that have a create date the same as their related lead.
This is what I have written but the CreatedDate = Lead.CreatedDate condition is not working for me.
Can anyone help me?
SELECT Id, CreatedById, CreatedDate,LeadId, Lead.LeadSource, Campaign.Type
FROM CampaignMember cm WHERE cm.CreatedDate = Lead.CreatedDate AND cm.CreatedById NOT IN ('00520000001dRbb', '00520000001d89w')
cm.CreatedDate = Lead.CreatedDate is not valid in SOQL. You have to find other way, and I support, what you are trying to achieve is not possible in a single query.
Regards,
Digamber Prasad