-
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
How to Communicate With Customers During Uncertain Times | Salesforce Guide
How do you communicate with your customers when they’re facing uncertainty? How do you move beyond basic customer transactions and create memorable, human moments? Is…
What is Pardot? What is Engagement History in Salesforce in 2023?
Pardot is a software as a service (SaaS) marketing automation platform by SalesForce offering email automation, targeted email campaigns, and lead management for B2B sales…
How to create custom Lookup in Lightning Component
Hi guys, Its time to use Lightning Component Framework. This framework is used to build a SPA. SPA is not a massage therapy as you…
Popular Salesforce Videos
Get Started with Salesforce Order Management in Commerce Cloud
This video will give you an overview of Salesforce Order Management and how to get started with implementing and using the application. In this session…
Salesforce To RDS Integration Through Dell Boomi | Salesforce Tutorial
Salesforce to RDS integration through Dell Boomi. This tutorial will cover the following points - 1. Introduction Take a quick glimpse at integrating accounts from…
Send Salesforce Field Service Mobile App Device Logs For iOS
This video will demonstrate how to send device logs from the Field Service App for iOS / Android. Salesforce Support may ask you to send…
