Apex Code Development You need to sign in to do that
Don't have an account?
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
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
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
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