-
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 Gmail Integration: Seamless Communication
As a continuously growing business and an esteemed Salesforce partner, we know and understand the importance of productivity. Time is a valuable resource that we…
How Does Salesforce Help in Customer Retention?
The process of acquiring customers is referred to as customer acquisition. Most organizations believe that growing revenue quickly is best achieved by attracting new customers.…
Salesforce Elastix Integration | All You Need to Know
In the dynamic landscape of customer relationship management, Salesforce has emerged as a game-changer. Businesses are continually seeking innovative solutions to enhance their CRM capabilities,…
Popular Salesforce Videos
Setup Visual Code Development Environment with Salesforce Org
In this Salesforce How-to video - You will learn how you can quickly get started in setting Visual Studio Code (VS Code) development environment for…
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…
What is Validation Rule in Salesforce?
Validation rules verify that the data a user enters in a record meets the standards you specify before the user can save the record. A…
