-
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
How to Freeze and Deactivate User Accounts in Salesforce
Introduction Here we are going to learn about how to freeze the user and deactivate the user. If your employee left your company then you…
What does Salesforce Tableau Integration mean for Customers?
Salesforce Tableau Integration - Salesforce is known for its acquisitions, always with a strategy to deliver comprehensive CRM features and world-class experiences to its stakeholders.…
Salesforce Marketing Cloud: A Beacon in the 2025 Digital Marketing Landscape
Salesforce Marketing Cloud has emerged as a dominant force in the digital marketing landscape. Its comprehensive suite of tools empowers businesses to deliver personalized, omnichannel…
Popular Salesforce Videos
Set Your Sales Cloud Implementation Up for Success
Make Sales Cloud a valued business tool that your sales reps will rely on by starting with these planning strategies and best practices for success.…
Salesforce Integration Crash Course | The Ultimate Guide to Salesforce Integrations
In these 100 minutes, you are going to learn almost all the integration concepts with the help of 2 projects. You will learn about API,…
Migrating from Salesforce NPSP to Nonprofit Cloud
The Salesforce Nonprofit Success Pack (NPSP) is a longstanding managed package with a user-friendly constituent management application and fundraising tool. However, Salesforce is pivoting nonprofit…
