-
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 20 Factors To Consider When Choosing CRM For Small Business | Salesforce
Small or mid-sized businesses are renovating our nation’s economic structure. They have delivered a huge contribution towards its enhancement by generating a magnitude of job…
Choosing the Right Salesforce Managed Services Provider: Tips and Tricks
Salesforce has become the backbone of customer relationship management (CRM) for many businesses, offering a powerful platform to manage customer interactions, streamline operations, and drive…
Google Teams Up With Salesforce to Push Cloud Computing Business
Do you know a strategic partnership is all set to disrupt the global cloud market? Yes, Salesforce recently announced its partnership with Google in order…
Popular Salesforce Videos
How to Create an Automated File Import in Salesforce Marketing Cloud
Cameron Robert shows how to create an automation to import files from your FTP into Data Extensions in Salesforce Marketing Cloud. File Import Automations are…
3 Must-Have Validation Rules in Salesforce to Save Time and Avoid Costly Mistakes
Validation rules in Salesforce act like quality checks for your data. They help make sure that the data in your Salesforce org is accurate and…
Salesforce Lightning Tutorial | Salesforce Developer Training for Beginners
This salesforce developer training for beginners video is a salesforce lightning tutorial where you will learn introduction to salesforce, salesforce components, salesforce lightning, lightning vs…