-
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
TriggerFactory in Salesforce Apex | The Developer Guide
Trigger structures in Apex are something clever. We as a whole realize we need them, we as a whole realize that it is best practice…
Salesforce Nonprofit Cloud: Get Started with a Free Trial
Salesforce Nonprofit Cloud offers a comprehensive suite of tools tailored to help nonprofit organizations manage their operations, from fundraising and program management to donor engagement.…
How to Add or Delete Dynamic Rows in Salesforce using Lightning Web Component
Introduction: Lightning includes the Lightning Component Framework and some exciting tools for developers. Lightning makes it easier to build responsive applications for any device. Lightning…
Popular Salesforce Videos
DreamTX Welcome Day 1 | Dreamforce 2020 | Salesforce
If you missed DreamTX DAY 1, then live this amazing experience here, we have covered it all for you. Let’s come together for the Dreamforce…
Salesforce Admin training : How to create a custom app in Salesforce?
In this tutorial, you will learn to create a custom app in Salesforce and go through a quick overview of Profiles. Profiles control the visibility of your…
Integrate Salesforce and Active Directory Step by Step
The prospect of implementing Single Sign-on in your Salesforce org can seem daunting if you are unfamiliar with the process. In this live step-by-step demo…
