-
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
Creating Multi Select Lookup in Salesforce
Hi All, There is always a requirement and also an idea that is being proposed of having Multiselect Lookup Relationship between the 2 objects that…
10 Steps to a Sustainable Salesforce Org
Salesforce is one of the most widely used CRM platforms in the world, enabling organizations to streamline their sales, marketing, and customer service operations. However,…
Learn All About Flows in Salesforce in 2023
What is a Flow in Salesforce? A flow is an automation tool in salesforce. In other words, it collects data or information and processes the…
Popular Salesforce Videos
Access Salesforce Maps Schedule and Manage Saved Events
Watch this video to learn how to Access Salesforce Maps Schedule and Review and Manage Saved Events. Do let us know in the comment section…
Pardot Engagement Studio | Salesforce
Learn how to use Pardot Engagement Studio to engage and attract prospective students. Do let us know in the comment section if you have any…
Email to case in Salesforce | Learn Salesforce
In this video, Shrey explained complete Record Level Security in Salesforce which includes: 1. What is Email-to-case in Salesforce? 2. Where can Email-to-case be used?…
