You need to sign in to do that
Don't have an account?
dJadhav
SOQL / SOSL to retrieve the CampaignMember
Hi,
How to retrieve the CampaignMember using the type(lead/contact) and operator like (equals, start with, contains)
Thanks in advance.
Regards,
Dipak
Use below query:--->
Select c.Lead.FirstName, c.Lead.LastName, c.LeadId, c.Contact.FirstName, c.Contact.LastName, c.ContactId From CampaignMember c WHERE c.Lead.LastName LIKE '%SEARCHSTRING%' or c.Contact.FirstName LIKE '%SEARCHSTRING%'
Hi Amul,
Thanks for reply.
I want to use "Type" in the query. On Manage Member page we search the existing campaign member using the type in combination with different operators. I want to implement same feature.
Regards, Dipak