-
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 Flow - A Brief Guide You Should Check
In today’s world we all want things to get done in less time, we all want speed. While handling a client, company wants to give…
Salesforce Product : Marketing Cloud
Salesforce Product : Marketing Cloud A platform with seven primary products that helps to reach out your customers at the right time, with the right…
Speed up Your Revenue Growth - Salesforce Revenue Cloud
A. Salesforce Donning a New Hat Salesforce, an entity better known for its world-class products and for offering varied services ranging from Customer Relation Management (CRMs) to Enterprise…
Popular Salesforce Videos
How to Set Up a Journey in Journey Builder
Learn to build a customer journey with guidance from our experts. This video provides an overview of Journey Builder features and best practices. Get expert…
Create Your First Salesforce App in 30 Minutes
In this session, we will design, build and deploy a Salesforce App in 30 minutes using the low code and Salesforce modern developer tooling. Presenter…
Salesforce Platform Quick Tip: How to Use Einstein Search
Want to improve your searches in Salesforce, and make them faster and more intuitive? In part one of this 2 part series, Trailblazer and Salesforce…