-
Is there any way in query to do Like against a List of Values?
Hi All,
Is there any way in query to do Like against a List of Values?
SELECT Id FROM Account WHERE Name LIKE IN:listName
where listName is a list of string. I can make a dynamic query by doing OR with all the elements, but I was looking for a more elegant way to do this.
Thanks
-
1 Reply
-
Hi Pranav,
You can do this by query like :-
String[] searchitem = {'%searchtext1%','%searchtext2%'};
List<Accounts> acc = [select id, name from Account where name like :searchitem];
Log In to reply.
Popular Salesforce Blogs
Insert Record using JavaScript Remoting with Visualforce Page
Hey there! We must have heard about javascript remoting. So today we are going to learn about how to use the Javascript remoting to build…
How to Capture Replies in Salesforce Using Email Services?
When you are sending Email by using trigger then you have to implement these codes in your trigger - String[] toAddresses = new String[] {lead1.email};…
Learn About Control Access to Object | Salesforce
If you want to control any type of data access then the easiest way is to assign permission on that specific object. Objects can be…
Popular Salesforce Videos
What is a Salesforce Architect?
If you are not familiar with the ‘Solution Architect’ role then it can be explained relatively simply. Solution Architects are ultimately responsible for the ‘Solution’…
Fillable PDFs for Salesforce Field Service
The ability to generate fillable PDFs for Salesforce Field Service can be a powerful tool. We demonstrate how to use PDFLib, a JavaScript library that…
Salesforce Mobile Publisher Demo
With Salesforce Mobile Publisher, you can create pixel-perfect mobile applications for employees, customers, and partners. Check out this video and learn all you need to…
