+ Start a Discussion
Nick GarrisonNick Garrison 

SOQL error Unknown error parsing query

I am trying to complete a request. The request is below followed by my answer.   Any help would be appreciated. 

At the end of the year, you’re updating staff members’ goals in Salesforce, which are
written as SOQL queries in a custom object. A team leader wants you to update the goal
for National Mid-Level Organizing Workshop Participants (current version below) to only
include members who are Leaders (“Leader” is the label for a custom boolean field on
the Contact object) and she would also like you to expand the definition to include
members who attend a program with the Track Type marked as “Organizing” or
“Collective Action.” Please edit the snippet below to make these changes.

CampaignMember.Status = 'Attended' AND CampaignMember.Member_Type__c = 'Member' AND
CampaignMember.Contact.Current_LEE_Member_RPT__c = TRUE AND
CampaignMember.Campaign.Program_Scope__c IN ('National') AND
(CampaignMember.Campaign.Track_Type__c INCLUDES ('Organizing' OR Collective Action)) AND Contact.Leader_c = True


 
Best Answer chosen by Nick Garrison
Steven NsubugaSteven Nsubuga
CampaignMember.Status = 'Attended' AND CampaignMember.Member_Type__c = 'Member' AND
CampaignMember.Contact.Current_LEE_Member_RPT__c = TRUE AND 
CampaignMember.Campaign.Program_Scope__c IN ('National') AND
(CampaignMember.Campaign.Track_Type__c IN ('Organizing' ,  'Collective Action)) AND Contact.Leader_c = True

All Answers

Steven NsubugaSteven Nsubuga
CampaignMember.Status = 'Attended' AND CampaignMember.Member_Type__c = 'Member' AND
CampaignMember.Contact.Current_LEE_Member_RPT__c = TRUE AND 
CampaignMember.Campaign.Program_Scope__c IN ('National') AND
(CampaignMember.Campaign.Track_Type__c IN ('Organizing' ,  'Collective Action)) AND Contact.Leader_c = True
This was selected as the best answer
Nick GarrisonNick Garrison
Thanks for the reply Steven