-
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
Enhance Your Marketing Effort With Salesforce Pardot
Each company can be different from another, whether in terms of industry or values, but one thing that remains common is the need for marketing.…
Salesforce Automation with Workflow Rules
Following our previous article on Salesforce Automation Tools, this article covers automation using the Workflow tool in more detail. Workflows are suitable for a single if/then statement that…
Custom Notification With Process Builder in Salesforce
Custom Notification is a modified notification where the administrator can add beneficiaries, subjects, and substances. Administrators can be sent a custom notification when any significant…
Popular Salesforce Videos
How to Logging Automated Emails on Related Records
Learn how to logging automated emails on related records. We will show you how to create a process builder using the package Send Emails. This…
Salesforce Flow: How to Build a Flow Data Table
In this video, Salesforce Made Simple gives a quick run-down on constructing a data table inside the Salesforce Flow Builder. Whether they’re buying movie tickets,…
Salesforce QA Interview Guidance Program
Do you want to learn what it takes to clear a Salesforce QA interview? In this video, Bava Dharani Ganesan gives a detailed explanation of…
