-
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
Salesforce Gamification – Read this before you implement it!
Salesforce Gamification – If you are reading this blog, it’s most likely that you’ve heard about gamification and how it spreads like a wildfire among…
All About Custom MetaData Types | The Salesforce Developer Guide
Custom metadata is packageable, adjustable, upgradeable, and deployable application metadata. To start with, you make a custom metadata type, which characterizes the type of application…
How to work with Salesforce1 Navigation Menu?
Hey guys, Everyone knows what is Salesforce1? But if you don’t know then I will define for you. Salesforce1 is a mobile app for Android,…
Popular Salesforce Videos
Add Styles and Data to a Salesforce Lightning Web Component
After completing this unit, you’ll be able to: Use CSS and Lightning Design System with a component. Get data from a Salesforce org. Deploy your…
Data Loader Alternative | Export and Import Data Using Salesforce Inspector
Find out how to export and import data using Salesforce Inspector, a very useful alternative to traditional data loader. watch this video and learn all…
Is the Salesforce Marketing Cloud the Future For Business?
As the market changes, one needs to keep up with the times. Companies are interested in Salesforce Marketing Cloud because it gives them a competitive…
