-
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
Apex Trigger In Salesforce - Get Started
The trigger is an apex code that executes before and after the DML operations. Following are the DML operations:- Insert Update Delete Upsert Merge Undelete…
Salesforce Appexchange App Development Services: InfoDrive Solutions
In today’s fast-paced business environment, companies strive to leverage cutting-edge technologies to drive growth, enhance efficiency, and improve customer experiences. Salesforce, a leading customer relationship…
noKodr as Rapid Prototype Solution to Business in 2024
Introduction In today's fast-paced world, businesses need to quickly validate their ideas and concepts before investing significant time and resources into development. This is where…
Popular Salesforce Videos
Salesforce SOAP API integration using Partner WSDL
This video is another one on our Salesforce Integration learning video series, through this video our experts will be going to demonstrate how to use…
Introduction to Salesforce Einstein OCR
In this session, we will learn about Einstein OCR and Create/Update Leads and Contacts using Business Cards. Let’s welcome an amazing #Summer20 release gem –…
Is Trailhead enough to crack Salesforce Interview?
In this video, Shrey answered one of the most asked questions related to Salesforce Interview. Let's see how beautifully Shrey answered this Question. We hope…