-
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 Salesforce Financial Services Cloud Solves Problems For FinTech Companies
Working in the financial services industry is not an easy-breezy thing to do. It is all about managing people’s wealth and helping them plan their lives, literally.…
4 Best Salesforce Sales Cloud Features to Boost Revenue and Business
The newest enhancements to Salesforce's Sales Cloud and Revenue Cloud, which concentrate on revenue intelligence, sales enablement, and subscription organization, have been made public. At…
Salesforce Kanban Board - All You Need to Know
The Kanban load-up was initially evolved in Japan ('Kanban' deciphers as 'announcement') by Toyota to work within the nick of time (JIT) assembling and conveyance. …
Popular Salesforce Videos
Multi-factor Authentication in Salesforce | Setup of MFA
Multi-factor Authentication in Salesforce: Salesforce offers simple, innovative MFA solutions that provide a balance between strong security and user convenience. Because your business requirements and…
Building a Business Case for an Investment in Salesforce - Education Cloud
Education Cloud is a leading platform that empowers your institution to become a Connected Campus, so you can transform the student journey. With the power…
See how fast and easy you can make intuitive Salesforce solutions to your users with Cauzali.
Instead of coding or very complex flows use Cauzali. Place your Cauzali model everywhere in Salesforce including in the middle of a Flow. Price between…
