-
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
Salesforce Customer Portal: Features, Industry Use Case, and Benefits
The ideal features in a customer portal may vary depending on the industry, business needs, and the types of customers that the portal is meant…
Salesforce Administrator Roles And Responsibilities
Salesforce is a cloud-based platform that helps a business organisation in managing valuable customer database efficiently. It provides highly automated services that allow the sales…
How can Salesforce CRM be used for Small Businesses?
With straightforward tools, a connected app, and Salesforce dashboards & analytics, small businesses can develop a thorough picture of their present and potential customers. By…
Popular Salesforce Videos
Salesforce Guide to Sharing Architecture
The Salesforce sharing model is an essential element in your organization's ability to provide secure application data access. Therefore, it's crucial to architect your sharing…
Introduction to Salesforce Shield Platform Encryption | Salesforce Tutorial
Introduction to Salesforce Shield Platform Encryption 0:00 Introduction 1:00 Shield Platform Encryption 2:35 Need for Shield Platform Encryption 3:18 Classic Encryption Vs Shield Platform Encryption…
Salesforce For Beginners - Introduction To Salesforce | Salesforce CRM Developement Tutorials
Contents for this Salesforce Training Video: 1:05 - Index 1:31 - What is CRM ? (Customer Relationship Management) 2:17 - What is Salesforce CRM? 3:18…
