-
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
Lightning DataTable in Salesforce | The Developer Guide
A lightning-datatable part shows even information where every segment can be shown depending on the information type. For instance, an email address is shown as…
4 Phases of Salesforce Classic to Lightning Migration
Salesforce Classic to Lightning Migration offers you access to better UI, new features, and more opportunities to scale. When Salesforce Lightning was launched in 2015,…
Best Practices of Apex In Salesforce - Here's the Complete Guide
Please follow these Salesforce Best Practices to improve our code Quality, Readability, and Reusability. Also, you can use Salesforce Best Practices to optimize our code.…
Popular Salesforce Videos
Salesforce Summer ’22 Release | Flow Enhancement of Summer 22 Release with Example
Exceed your business goals with the Summer ’22 release by seamlessly integrating your data, finding meaningful insights, and building lifelong customer relationships. How to Use…
Explore Record Triggered Flow | Learn Salesforce Lightning Flows | Flow Builder Videos
Creating or updating a record can trigger an auto-launched flow to make additional updates to that record before it's saved to the database. A record-triggered…
How To: Build A Salesforce Career with This Tool!
Timecodes 0:00 - Intro & Overview 0:57 - Talent Stacker 3:00 - Career Progression 10:08 - Flow is the Future 13:36 - Learn More/Outro If…