function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
sfdev22sfdev22 

Relationship query on Campain

How do I make a Relationship query on Campain,CampaignMember,Lead so I retrieve all Leads for a given campaign in one query?
digeratadigerata
I want to do the exact same thing.  Did you figure this out?

I've tried these queries:

select LeadId, Campaign.Name, Lead.FirstName, Lead.LastName, Status, HasResponded from CampaignMember where Campaign.Name = 'CampaignName'

select Name, (select LeadId, Lead.FirstName, Lead.LastName, Status, HasResponded from CampaignMembers) from Campaign where Campaign.Name = 'CampaignName'


Both of them return null for the Lead.FirstName and Lead.LastName fields.  Though the value for LeadID is the correct LeadID.

Any ideas?