-
ORs and ANDs in the retrieve function of Visualforce Remote Objects
How do I specify an or of one field's value? For instance, how do I build a query for an account where (BillingState is any of (Hawaii, Alaska, or California)) and (Name is like % Assoc%)?
The obvious answer (below) does not work, because JS engines will simply use the last value for BillingState ({ eq: 'California'}):
-
1 Reply
-
Hi Piyush,
Try this code:-
where: {
or: {
BillingState: { eq: 'Hawaii' },
or: {
BillingState: { eq: 'Alaska' },
or: {...},
},
},
Name: { like: '% Assoc%' }
}
Log In to reply.
Popular Salesforce Blogs
Salesforce Education Cloud Summer '25 Highlights
School’s (almost) out, innovation is in! Salesforce’s Summer ‘25 release is bringing improvements to Education Cloud, like new use cases for Agentforce for Education and…
Master the Art of Customer Service with Case Management | Salesforce
What is the top priority for any business today? If you anticipated it as ‘Customer Experience’, you are probably right. Recent research found that nearly…
To Do Checklist Before Code Commit In Production
TO DO CHECKLIST BEFORE CODE COMMIT IN PRODUCTION Proper commenting in code (Test Class, Apex Class, Trigger, Vf page), if you modified or create new…
Popular Salesforce Videos
5 Tips on How to Run Your Pipeline Engine to Drive Growth | Salesforce on Salesforce
Salesforce’s revenue has been on a firm upward trajectory for years, and every year we see terrific growth. How do we do it? I’ll let…
Salesforce Editions Explained
In this video, we break down the Salesforce Editions—Essentials, Professional, Enterprise, and Unlimited—to help you understand which one is best for your business. Whether you're…
Setting Up Service Territories and Operating Hours | Salesforce Webinar
Scale your business and ensure optimized performance by setting up service territories in Salesforce Field Service. In Salesforce Field Service, operating hours represent service territory…
