-
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
Log In to reply.
Popular Salesforce Blogs
How to Boost Your Sales Process with Salesforce CPQ
Salesforce CPQ allows you to use features like customizations, discounts, quantities, etc. This in return enables the sales representative to quote the price faster and…
Why Salesforce is the Most Preferable CRM for Businesses?
In the realm of CRM, Salesforce has emerged as one of the most powerful and embraced solutions with maximum users acceptance rate. The market share…
Meet Your On-Call Data Scientist Unit | Salesforce Developer Guide
We should Figure Out Why Those Margins Are Shrinking. Envision that you are the VP of activities for a significant car provider. You're answerable for…
Popular Salesforce Videos
Salesforce Grid Component Modernization with Webix Widgets
Take a break and watch a short video about how we modernized the Salesforce Grid component with Webix.
Skills for Salesforce Field Service | Optimize Customer Service for Businesses | Salesforce Webinar
One way to optimize customer service operations is by having the right technician for the right job. How? Skills for Salesforce Field Service is the…
How to Log an Admin Assist Support Case in Help and Training in Salesforce Help
Do you need to log a case with Admin Assist Salesforce Support but aren't sure how to go about it? Do you need help filling…