-
how to avoid this salesforce error
Database.query error getting Events! Exception: unexpected token: 'FROM'
SELECT Id,Name, geolocation__c,Location__c, geolocation__Latitude__s , geolocation__Longitude__s, Date_of_Onsite_Event__c, Local_Start_Time_of_Event__c, Local_End_Time__c,Local_End_Time_of_Event__c, Number_of_Hours_of_Event__c, End_Date_of_Onsite_Event__c, Services_to_be_Provided__c,( SELECT Id, Contact__c,Contact__r.Provider_Level__c, FROM Provider_Onsite_Event__r where Contact__r.Provider_Level__c =:'Coordinator- Level 1 ), FROM Onsite_Event__c WHERE Publish__c = 'Yes' AND Date_of_Onsite_Event__c > TODAY AND DISTANCE(geolocation__c, GEOLOCATION(13.5603,78.5036),'mi') < 100 ORDER BY DISTANCE(geolocation__c, GEOLOCATION(13.5603,78.5036),'mi') LIMIT 50 -
2 Replies
-
Hi shiva,
try the plural name of child object in sub query.
-
Hi sfdc,
Check your Child Relationship Name, you can check by following steps :-
1. Go to the view fields section of that sobject.
2.Click the field label that you want to check(Master Detail or LookUp field).
3.There you will get the Child Relationship Name, use it to your query.
Hope this helps.
Log In to reply.
Popular Salesforce Blogs
Top 8 Salesforce Integrations for Small and Medium-Sized Businesses
At Cloud Analogy, we understand the importance of efficient business processes for Small and Medium-sized Businesses (SMBs). Salesforce, a leading Customer Relationship Management (CRM) platform,…
What Makes Salesforce CRM A Right Fit For Any Business Size?
What comes to your mind when I say the term an effective Customer Relationship Management? Did the bright smiles or over-enthusiastic thank you replies of…
Top Salesforce Spring '23 Release Features
The wait is finally over. Salesforce Spring '23 release features are here and we cannot wait to discover the outstanding releases. As we know by…
Popular Salesforce Videos
We are the Salesforce Development Company you are looking for!
From startups to enterprises, we help organizations make more out of their Salesforce CRM. We are end-to-end Salesforce development experts. And yes, we will redefine…
Introduction to Lightning Web Components (LWC)
Why Lightning Web Component (LWC) Part 1 - Vanilla HTML5 Web Components Benefits of Web Component Pillars of Web Component Demo of Custom Element and…
Permissions In Salesforce Experience Cloud Explained | Salesforce Communities
A permission set is a collection of settings and permissions that give users access to various tools and functions. Permission sets extend users' functional access…
