-
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.